Skip to Content

ABAP Module to process Excel File

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • author's profile photo
    Former Member
    Sep 30, 2005 at 12:53 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 30, 2005 at 12:58 AM

    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:

    excel-to-internal-table

    Hope this helps.

    Cheers,

    Pat.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 30, 2005 at 04:50 AM

    Hi Nick,

    I think this Fm will help you

    <b>ALSM_EXCEL_TO_INTERNAL_TABLE.</b>

    Try it.

    Regards,

    Viswanath Babu

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 30, 2005 at 04:57 AM

    Hi Nick,

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

    more than you want

    thanks

    surjit

    Add comment
    10|10000 characters needed characters exceeded