Can we download 2 excel sheet in excel from two different program by using GUI_DOWNLOAD

[former_member544532]

Dear all,

My requirement is to download 2 excel sheet in a single excel file from 2 different program. Is it possible by using GUI_DOWNLOAD. Important think is excel sheet name must be custom. Please share you idea.

[tom_wan · Accepted solution]

Hi Renuka

The file created by GUI_DOWNLOAD is just a TEXT file with .xls or .xlsx file extension. As it is not a REAL excel file so you can not generate excel sheets. Instead, you can use OLE to generate REAL excel file.

Regards

Tom

[matt · Accepted solution]

Or ABAP2XLSX

[SimoneMilesi · Accepted solution]

Or give a look at Luksaz's blog

http://abapblog.com/articles/tricks/33-create-xlsx-mhtml-file-from-internal-table-in-background