Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Upload excel file having two sheets data into two internal table

Bharath84
Participant

‎09-13-2019 2:55 PM

0 Kudos

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

2 REPLIES 2

SimoneMilesi
Active Contributor

‎09-16-2019 9:22 AM

Go for ABAP2XLSX: really easy and fast to use.