Community
Application Development and Automation 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: 
Read only

Upload excel file having two sheets data into two internal table

Bharath84
Participant

‎2019 Sep 13 2:55 PM

0 Likes
1,190

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

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

Reply
2 REPLIES 2
Read only

binhlht
Participant

‎2019 Sep 15 3:22 AM

0 Likes
921

Try this one

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

Read only

SimoneMilesi
Active Contributor

‎2019 Sep 16 9:22 AM

921

Go for ABAP2XLSX: really easy and fast to use.