How to create Excel using two internal table

[Former Member]

Hello Expert,

I have two internal tabe, I want to export these two internal table data into Excel with two excel tab. So export excel sheet should have two tab and each tab should conatin one internal table data.

Thanks in advance.

[surajarafath]

Use excel_ole_standard_dat FM

in that you have a Import parameter of DATA_SHEET_NAME

iin that you give sheet1 and sheet2.

You need to use this FM twice .

[former_member229034]

Hi Chetan,

Go through the following solutions and one of those or all could definitely help you.

1. Go through the inline links for helpful programs. I am sure you can make some tweaks and changes from these programs and download two internal tables into two different tabs in an excel sheet.

http://abaplovers.blogspot.com/2008/05/abap-internal-table-to-excel-sheet.html

***REMOVED BY MODERATION*** (invalid URL)

***REMOVED BY MODERATION*** (invalid URL)

2. There is a Function module : SAP_CONVERT_TO_XLS_FORMAT . You can use this and check if this helps solve your purpose.

3. Alternatively, you can use OLE and write a program to download internal table data into Spreadsheets. Pls post back for further help.

***REMOVED BY MODERATION*** (invalid URL)

***REMOVED BY MODERATION*** (invalid URL)

Best,
Chaitanya