Upload Excel file using GUI_UPLOAD

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi Ratan,

Instead of using GUI_UPLOAD

use,

ALSM_EXCEL_TO_INTERNAL_TABLE function module.

this will help you.

[Former Member]

Have a look at this thread.

I have put the code how to use FM

ALSM_EXCEL_TO_INTERNAL_TABLE

Cheers

A

[Former Member]

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]

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.

[Former Member]

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

. . .

. . .

[Former Member]

ie

ROW COL VALUE

1 1 10

1 2 20

. . .

. . .