Excel to internal table using abap2xlsx

[jakub_plocki]

Hi,

recently I started to use abap2xlsx in my project and it's brilliant.

Now I would like to replace other excel-related technologies / classes and here comes a question.

Is there any ready-to-use method for reader class that will return dynamic table with a non-empty content of selected worksheet? I've reviewed ZCL_EXCEL_READER_2007 methods and demo programs, but didn't found anything suitable. Of course I found methods to build own method, but I prefer already implemented (and tested) options.

Currently I'm using CL_FDT_XL_SPREADSHEET class and its method:

er_data = lo_excel_ref->if_fdt_doc_spreadsheet~get_itab_from_worksheet( lv_woksheetname ).

but it has a problems with some data types and returns not correct values.

Thanks in advance.

BR,
Jakub

[jakub_plocki]

Why can't you use the abap2xlsx reader? What is the issue with it?

[abo]

Not at the moment, unfortunately.

There is a related project that does what you want, I have asked the author to send a PR.

EDIT: PR incoming

[Sandra_Rossi]

Why can't you use the abap2xlsx reader? What is the issue with it?