topic ABAP Module to process Excel File in Application Development and Automation Discussions

ABAP Module to process Excel File

Former Member — Fri, 30 Sep 2005 00:18:20 GMT

Hello:

Does anyone have a sample ABAP module that will read an Excel file? I need to read an Excel file and extract the information in each column as a field that is either fixed length in some columns or variable in some columns and it will be delimited by each column.

Thanks,

Nick F.

Re: ABAP Module to process Excel File

Former Member — Fri, 30 Sep 2005 00:53:37 GMT

Where's the problem in using FM GUI_UPLOAD if you are doing it from your desktop?

Re: ABAP Module to process Excel File

former_member221770 — Fri, 30 Sep 2005 00:58:51 GMT

Nick,

If the Excel file is saved as a Tab Delimited Text File, you can use FM "GUI_UPLOAD" like syd_oz said.

or you can see the following link:

Hope this helps.

Cheers,

Pat.

Re: ABAP Module to process Excel File

Former Member — Fri, 30 Sep 2005 04:50:44 GMT

Hi Nick,

I think this Fm will help you

<b>ALSM_EXCEL_TO_INTERNAL_TABLE.</b>

Try it.

Regards,

Viswanath Babu

Re: ABAP Module to process Excel File

Former Member — Fri, 30 Sep 2005 04:57:04 GMT

Hi Nick,

just search for 'Excel' in forum and you will get

more than you want

thanks

surjit