Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Upload with multiple tabs on AL11 SAP ABAP

sarya1991
Explorer
0 Kudos
2,764

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

8 REPLIES 8

vijay_hariharan
Contributor
0 Kudos
1,536

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

0 Kudos
1,536

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.

1,536

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
Active Contributor
0 Kudos
1,536

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

sarya1991
Explorer
0 Kudos
1,536

I didnt find any suitable answer for my question.

matt
Active Contributor
1,536

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
Explorer
0 Kudos
1,536

Hi Shailendra,

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