Reading EXCEL (*.XLS) file from DESKTOP in BACKGROUND MODE

[former_member221838]

Hi Experts,

I need to read an excel file from desktop (presentation server) and then populate custom database table. But condtion is to process all this in background mode.

For foregorund I have used FM 'ALSM_EXCEL_TO_INTERNAL_TABLE'. But it doesnt work for background mode as it has statement '* read clipboard into ABAP CALL METHOD call_gui_frontend_services=>clipboard_import'.

Someone told me that its not possible to read XLS from desktop in background mode. (???)

Could you please suggest me any other way or any good solution?

Thanks and Regards,

Nikhil J.

[Former Member · Accepted solution]

Hi,

Upload from presentation server is not possible in background. You need 2 steps: First transfer from presentation to application server in dialog, second read file from application server in background.

best regards

Sabine

[former_member221838]

Edited by: Nikhil Jathar on Jan 19, 2009 3:07 AM