11-26-2021 1:17 PM
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
11-26-2021 1:24 PM
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
11-29-2021 8:22 AM
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.
11-29-2021 9:13 AM
You don't create anything on AL11. AL11 is a transaction that allows you to look at the file system of the application server.
11-26-2021 3:03 PM
11-29-2021 8:19 AM
11-29-2021 8:29 AM
11-29-2021 9:22 AM
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).
02-24-2023 10:44 AM
Hi Shailendra,
Did you find the sloution, I have similar requirement. Thanks