Reading Excel file from Application Server into ABAP Internal Table

[former_member758204]

Hi ,I am using https://praveensg8.files.wordpress.com/2015/04/reading-excel-file-from-application-server-into-abap-... ,this link to read .xlsx data from application server. but i only read single sheet data . i want to read multiple sheet data in single excel file. the excel file available in al11.pls help me

[former_member751964]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with Community Q&A, as the overview provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line.

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial Q&A tutorial

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a Picture to your profile you encourage readers to respond.

[abo]

Seems like you should use abap2xlsx

It comes with plenty of demos, including one that reads back a file.

[Sandra_Rossi]

Already asked here, and abap2xlsx was already proposed yesterday 😉

[matt]

Just think about how much time you'd have saved if you'd have put something like

AL11 XLSX Internal Table multiple sheets site:sap.com

into a search engine.

You clearly do know how to search, as you found the blog. 😉