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
Showing results for 
Search instead for 
Did you mean: 

Upload Excel file using GUI_UPLOAD

Former Member
0 Kudos

I'm trying to upload a regular excel (*.xls) using the fm <b>GUI_UPLOAD</b>, though sy-subrc is set to 0 after the function call, the data that is uploaded into the internal table shows junk. Any thoughts are welcome.

6 REPLIES 6

Former Member
0 Kudos

Hi Ratan,

Instead of using GUI_UPLOAD

use,

ALSM_EXCEL_TO_INTERNAL_TABLE function module.

this will help you.

Former Member
0 Kudos

Have a look at this thread.

I have put the code how to use FM

ALSM_EXCEL_TO_INTERNAL_TABLE

Cheers

A

Former Member
0 Kudos

Hi,

save your excel file with tab delimeter then use GUI_UPLOAD function module

for upload the file data to internal table.if u do like this it won't show the junk data.

Former Member
0 Kudos

Thanks all for all the replies. I'm aware of the function module suggested, however the question that I want to put forward is : is it not possibe to upload a regular excel file(*.xls) using the fm GUI_UPLOAD. I apologize for the confusion.

0 Kudos

Hi Ratan,

There is no confusion in this,

you can do this with GUI_UPLOAD but you will not get the uploaded internal table data in

a right and organised way.

but in case of ALSM_EXCEL_TO_INTERNAL_TABLE you will get those uploaded internal table data as below.

ROW COL VALUE

1 1 10

1 2 20

. . .

. . .

0 Kudos

ie

ROW COL VALUE

1 1 10

1 2 20

. . .

. . .