topic Re: Upload excel file in Application Development and Automation Discussions

Upload excel file

Former Member — Tue, 11 Jul 2006 08:39:05 GMT

Hi all,

I am trying to upload excel sheet data into ITAB.

Unfortunately, in my SAP system there aren't 'ALSM_EXCEL_TO_INTERNAL_TABLE', TEXT_CONVERT_XLS_TO_SAP' and 'SAP_CONVERT_TO_CSV_FORMAT' FM.

Can u help me?

Thanks

Agata

Re: Upload excel file

Former Member — Tue, 11 Jul 2006 08:40:40 GMT

Hi agatar,

1. In that case,

2. Its best to save the excel file

as TAB DELIMITED FILE

(using excel only)

3. then upload the file using

GUI_UPLOAD FM.

regards,

amit m.

Re: Upload excel file

Former Member — Tue, 11 Jul 2006 08:40:40 GMT

Hello,

I can use this Fm KCD_EXCEL_OLE_TO_INT_CONVERT

call function 'KCD_EXCEL_OLE_TO_INT_CONVERT'

exporting

filename = i_filename

i_begin_col = l_begin_col

i_begin_row = l_begin_row

i_end_col = l_end_col

i_end_row = l_end_row

tables

intern = xt_intern

exceptions

INCONSISTENT_PARAMETERS = 201

UPLOAD_OLE = 201.

if sy-subrc <> 0.

e_subrc = sy-subrc.

exit.

endif.

If useful reward points,

Regards,

Vasanth

Re: Upload excel file

Former Member — Tue, 11 Jul 2006 08:42:28 GMT

Hi,

Use FM GUI_UPLOAD to upload Excel,

Rgds,

Re: Upload excel file

Former Member — Tue, 11 Jul 2006 08:42:33 GMT

Hi,

Check these examples..

http://www.sapdevelopment.co.uk/file/file_upexcel.htm

http://www.sapdevelopment.co.uk/file/file_upexcelalt1.htm

http://www.sapdevelopment.co.uk/file/file_upexcelalt2.htm

Regards

vijay

Re: Upload excel file

Former Member — Tue, 11 Jul 2006 08:44:19 GMT

Hi,

if none of them are available then save the excel sheet as Tab Delimited text file and then Upload using the <b>GUI_UPLOAD</b> FM.

Regards

vijay

Re: Upload excel file

Former Member — Tue, 11 Jul 2006 08:44:59 GMT

hi,

Use FM <b>GUI_UPLOAD</b>

Check this thread out for the same

Regards,

Santosh

Re: Upload excel file

Laxmana_Appana_ — Tue, 11 Jul 2006 08:47:15 GMT

Hi,

Copy the Excel file data into text file and save the file with '.txt' format and use FM : GUI_UPLOAD to upload the text file.

or check for below FM's :

UPLOAD,WS_UPLOAD

Regards

Appana

Message was edited by: L Appana

Re: Upload excel file

Former Member — Tue, 11 Jul 2006 08:47:24 GMT

Hi,

Very simple way to upload the excel file to internal table is using FM 'GUI_UPLOAD'.

For Eg,

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = logfile-pc_file

FILETYPE = 'DAT'

HAS_FIELD_SEPARATOR = 'X'

tables

data_tab = itab_excel

EXCEPTIONS

OTHERS = 1.

Thanks,

Neptune.M

Plz reward if it helps.

Re: Upload excel file

Former Member — Tue, 11 Jul 2006 09:25:02 GMT

save the file in txt mode and upload it thru GUI_Upload fnmodule

Re: Upload excel file

Former Member — Tue, 11 Jul 2006 10:39:29 GMT

Thanks, but I haven't this FM, too!!!!