from sap to excel file with different sheets?

[Former Member]

can i upload an internal table from SAP to single Excel file with different sheets for example like : sheet1, sheet2, sheet3.......sheet10. , but need to upload data from sap to excel worksheets ie. from multiple named tabs in Excel. Is this possible, and if so, please can you help and advise me how?

thanks

venkat.

Edited by: Matt on Feb 16, 2009 2:15 PM Removed excessive question marks...!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[Former Member]

Hi,

Please Check with the following link.

http://www.ittestpapers.com/articles/862/1/SAP-report-to-transport-data-into-an-excel-file/Page1.htm...

Thanks,

Neelima.

[Former Member]

Hi Venkat,

Please Find the LInk Below it has code to download in different Sheets

[Link1|]

[Link2|]

Hope this will be Helpful

Thanks

Kalyan

[aditya_aghor]

Hi venkat,

Yes indeed it is possible to write data from internal table to different excel sheets. Check out SAP's Microsoft OLE functionality.Search on SDN for OLE . Following are some links

https://www.sdn.sap.com/irj/scn/wiki?path=/display/abap/sample%252bprogram%252bto%252bopen%252bexcel...

You can also check out FM ALSM_EXCEL_TO_INTERNAL_TABLE to check how to read different worksheets.

Using the above two resources you can create a program that can upload data to multiple worksheets in the same workbook.

Also see this link

Edited by: aditya aghor on Feb 16, 2009 1:57 PM

Edited by: aditya aghor on Feb 16, 2009 2:02 PM

[Former Member]

Refer this link

[Subhankar]

Hi ,

Check the links

[;

[;