Excel to internal table using abap2xlsx

jakub_plocki — Mon, 07 Mar 2022 14:56:10 GMT

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

Re: Excel to internal table using abap2xlsx

abo — Mon, 07 Mar 2022 15:37:22 GMT

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

Re: Excel to internal table using abap2xlsx

Sandra_Rossi — Mon, 07 Mar 2022 19:08:49 GMT

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

topic Excel to internal table using abap2xlsx in Application Development and Automation Discussions

Excel to internal table using abap2xlsx

Re: Excel to internal table using abap2xlsx

Re: Excel to internal table using abap2xlsx