ABAP Module to process Excel File

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[former_member221770]

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.

[Former Member]

Hi Nick,

I think this Fm will help you

<b>ALSM_EXCEL_TO_INTERNAL_TABLE.</b>

Try it.

Regards,

Viswanath Babu

[Former Member]

Hi Nick,

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

more than you want

thanks

surjit