topic Re: Upload Excel file using GUI_UPLOAD in Application Development and Automation Discussions

Upload Excel file using GUI_UPLOAD

Former Member — Thu, 06 Dec 2007 14:27:08 GMT

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.

Re: Upload Excel file using GUI_UPLOAD

Former Member — Thu, 06 Dec 2007 14:29:43 GMT

Hi Ratan,

Instead of using GUI_UPLOAD

use,

ALSM_EXCEL_TO_INTERNAL_TABLE function module.

this will help you.

Re: Upload Excel file using GUI_UPLOAD

Former Member — Thu, 06 Dec 2007 14:31:10 GMT

Have a look at this thread.

I have put the code how to use FM

ALSM_EXCEL_TO_INTERNAL_TABLE

Cheers

Re: Upload Excel file using GUI_UPLOAD

Former Member — Thu, 06 Dec 2007 14:40:21 GMT

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.

Re: Upload Excel file using GUI_UPLOAD

Former Member — Thu, 06 Dec 2007 14:47:37 GMT

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.

Re: Upload Excel file using GUI_UPLOAD

Former Member — Thu, 06 Dec 2007 14:56:40 GMT

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

. . .

Re: Upload Excel file using GUI_UPLOAD

Former Member — Thu, 06 Dec 2007 14:58:03 GMT

ROW COL VALUE

1 1 10

1 2 20

. . .