topic Reading XSLX multiple sheet from application server in Application Development and Automation Discussions

Reading XSLX multiple sheet from application server

Former Member — Mon, 17 Sep 2018 13:03:44 GMT

Hello,

I am trying to read XSLX document with multiple sheets into internal table. I have followed the document to make the development.

https://praveensg8.files.wordpress.com/2015/04/reading-excel-file-from-application-server-into-abap-internal-table_1.pdf

It is working fine for 3 sheets in one XSLX document. As I add 4th sheet, the internal table is having empty rows. And some times, some columns have values and some not.

Please help me.

Re: Reading XSLX multiple sheet from application server

Domi — Fri, 28 Sep 2018 20:27:48 GMT

It's ok to copy code - but one should understand it BEFORE use it!

Check the data in the excel and adjust the XSLT z_trans_import_xls (the large one, if you have renamed it)

regards

Domi

Re: Reading XSLX multiple sheet from application server

Former Member — Wed, 24 Oct 2018 09:02:23 GMT

Hi Domi,

The issue has been fixed. The issue occurred because, the shared string was not read correctly from the part table.

Thanks.

Regards,

Ravi Varma