Skip to Content

How to read excel data in web dynpro abap?


Dear Webdynpro Experts,

                                         I am stuck with an issue. I want to read xl data in web dynpro application for it I am submitting an zreport like this below stm

                                                 submit ztest and return.

                                    In Ztest program I am calling fm  ALSM_EXCEL_TO_INTERNAL_TABLE here while running my web dynpro application I am getting an error like

ERROR: Error during import of clipboard contents (termination:

ABORT_MESSAGE_STATE)

Note : I understood that this FM cannot be used in background but I want to execute it in background. Please help me with good solutions.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 21, 2015 at 12:14 PM

    This FM use OLE, so it's false to write "this FM cannot be used in background" but you should wrote 'this FM can only be used when connected to a SAP GUI session" so not in Web Dynpro. Even some trust browser controls can raise error too...

    Regards,

    Raymond

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2015 at 03:33 PM

    Hi Matala,

    Mentioned FM can not be used in case of WD. Rather use class cl_fdt_xl_spreadsheet.

    This link will help you.

    http://zevolving.com/2013/11/abap-webdynpro-upload-excel-file-using-class-cl_fdt_xl_spreadsheet/

    Add comment
    10|10000 characters needed characters exceeded