topic Re: Excel upload problem in Application Development and Automation Discussions

Excel upload problem

Former Member — Fri, 02 Dec 2011 04:44:30 GMT

Hi Friends,

I am trying to upload data from Excel file to internal table using "GUI_UPLOAD". My SAP system is on low patch and it is not supporting any OLE FM to upload Excel into internal table.

I am facing problem whenever excel cell contain text with ',' or ". When I upload text contain those text, internal table will come with extra ".

Could you please suggest way to overcome?

Thanks & Regards

Re: Excel upload problem

Arun_Prabhu_K — Fri, 02 Dec 2011 05:06:02 GMT

Hi Amit.

Try using the FM TEXT_CONVERT_XLS_TO_SAP for uploading data from Excel to Internal table.It works fine.

Cheers.

Re: Excel upload problem

former_member222709 — Fri, 02 Dec 2011 05:08:21 GMT

Hi Amit,

These are identifiers that are used by Excel. Hence, the simplest way to overcome this problem is to save your excel file as a 'Tab delimited text file' and upload the text file.

Regards,

Pranav.

Re: Excel upload problem

Former Member — Fri, 02 Dec 2011 06:09:53 GMT

Dear amit,

try to use filetype 'dbf' then try to upload xls file.

Re: Excel upload problem

Former Member — Fri, 02 Dec 2011 06:48:34 GMT

Try to save the excel file as MS 97-2003 version. Then use the FM "TEXT_CONVERT_XLS_TO_SAP" instead of GUI_UPLOAD.

Re: Excel upload problem

Former Member — Fri, 02 Dec 2011 08:34:53 GMT

hi Amit,

use TEXT_CONVERT_XLS_TO_SAP FM. it will work fine. but plese take care it did't work for xlsx type of file so save your file in 2003 format and then uupload it.

Cheers,

Ankitesh

Re: Excel upload problem

Former Member — Fri, 02 Dec 2011 09:03:08 GMT

Hi,

Try FM ALSM_EXCEL_TO_INTERNAL_TABLE to upload from Excel to Internal Table

Regards/Ali

Re: Excel upload problem

former_member187983 — Fri, 02 Dec 2011 09:07:25 GMT

Hi,

Can you use this funcation module alsm_excel_to_internal_table this funcational module work direct Excel to internal table please check .

Thanks & Regards

BRS

Re: Excel upload problem

former_member187983 — Fri, 02 Dec 2011 09:07:50 GMT

Hi,

Can you use this funcation module alsm_excel_to_internal_table this funcational module work direct Excel to internal table please check .

Thanks & Regards

BRS

Re: Excel upload problem

Former Member — Fri, 02 Dec 2011 09:37:02 GMT

Hi,

Try this FM :

ALSM_EXCEL_TO_INTERNAL_TABLE

It will useful.

Ram.