Download Smartform each page data into each tab of excel sheet dynamically

[Former Member]

Hi.

I want download each page data of smartform into each tab of excel sheet dynamically.

Suppose in my output of the smartform i got 10 pages. Then each page data i want download into each tab of excel sheet. So, in my Excel sheet i want 10 tabs with each page data separately.

Give me with an example if possible.

Thank You.

[messier31]

I don't have code but yeah pseudo logic should be ok.

At every new page you will have how many lines have been printed on current page. So on new page you call program line and put your code to insert these lines in new sheets each time.

Please check excel OLE coding examples for creating excel file and adding sheets using ABAP. There are many exmples you will find on SDN.

Enjoy SAP.

Pankaj Singh.