topic Re: How to create Excel using two internal table in Application Development and Automation Discussions

How to create Excel using two internal table

Former Member — Fri, 18 Nov 2011 09:28:34 GMT

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.

Re: How to create Excel using two internal table

surajarafath — Fri, 18 Nov 2011 09:38:00 GMT

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 .

Re: How to create Excel using two internal table

former_member229034 — Thu, 27 Feb 2025 20:05:58 GMT

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)

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)

Best,
Chaitanya