How to read excel data in web dynpro abap?

[Former Member]

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.

[jitendra_it]

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/

[raymond_giuseppi]

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