Reading XSLX multiple sheet from application server

[Former Member]

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-...

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.

[Former Member]

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

[Domi]

Hi

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

[Former Member]

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