topic Upload excel file having two sheets data into two internal table in Application Development and Automation Discussions

Upload excel file having two sheets data into two internal table

Bharath84 — Fri, 13 Sep 2019 13:55:18 GMT

Hi All,

I have an excel file with two worksheets and each sheets having some data. I have to upload data from sheet1 into ztable1 and sheet2 data into ztable2. I know we can use FM ALSM_EXCEL_TO_INTERNAL_TABLE to upload excel file. But here I have two worksheets in the excel file. Please let me know if anyone have uploaded excel file data with two sheets, can please share sample code.

Thanks,

Haritha

Re: Upload excel file having two sheets data into two internal table

binhlht — Sun, 15 Sep 2019 02:22:50 GMT

Try this one

http://abap-explorer.blogspot.com/2008/12/upload-data-from-multiple-worksheets-of.html

Re: Upload excel file having two sheets data into two internal table

SimoneMilesi — Mon, 16 Sep 2019 08:22:19 GMT

Go for ABAP2XLSX: really easy and fast to use.