Excel Upload with multiple tabs on AL11 SAP ABAP

[sarya1991]

Hi geeks,

I have two internal table with data for Eg LT_VBAK and LT_VBAP.

Now i need to create & upload excel file with above internal table where first VBAK data will sit in first sheet and VBAP data will sit in second sheet of same excel and i need to upload this excel into AL11 .

can any one help me out with this

[vijay_hariharan]

This is probably already answered. Check the entire thread below:

https://answers.sap.com/questions/11579739/read-and-write-multiple-sheets-of-xl-placed-on-al1.html

Regards,
Vijay

[sarya1991]

this thread described to upload the multiple sheet excel on SAP from presentation layer or desktop, but my requirement is to create multiple sheet excel on AL11.

[matt]

You don't create anything on AL11. AL11 is a transaction that allows you to look at the file system of the application server.

[Sandra_Rossi]

It's been already asked and answered lots of times in the forum.

[sarya1991]

I didnt find any suitable answer for my question.

[FredericGirod]

https://abapblog.com/articles/tricks/120-create-xlsx-file-from-internal-table-in-background-v2

[matt]

You don't create anything on AL11. AL11 is a transaction that allows you to look at the file system of the application server. You have no requirement to "upload to AL11". You have a requirement to create an excel spreadsheet, with tabs, into the application server of the file system.

Search

1. How to create multitab spreadsheets (hint abap2xlsx).

2. How to write a binary file to a directory on the application server. (hint OPEN DATASET).

[VISHAL_JHA]

Hi Shailendra,

Did you find the sloution, I have similar requirement. Thanks