Error while executing function "ALSM_EXCEL_TO_INTERNAL_TABLE"

[Former Member]

Dear experts,

I am uploading the data from excel file using ALSM_EXCEL_TO_INTERNAL_TABLE function module in one of the report. The function goes well in the backend but

unfortunately, when I run the web, it throws an error: Error during import of clipboard contents, error key: RFC call ended with "System Failure" exception.I have enter to SU22 and find no errors about it.Have you guys ever met this problem? Please show me the the solution, or guide me how to fix this error.

Thanks in advance.

[raymond_giuseppi]

This FM uses both

• OLE2 to interact with Excel (trigger a "select" and "copy" of data from Excel)
• GUI class cl_gui_frontend_services (trigger the "paste" into SAP)

So won’t work in Web,  also not working in background job, because it lacks a connection to a SAPGUI.

Regards,

Raymond

[Former Member]

thanks,but I need to upload the data to internal table from excel file what should i do if I can't use this FM?

I also try to use 'GUI_UPLOAD' but it shows "gui_refuse_filetransfer ".

[raymond_giuseppi]

Forget to use any tool with "GUI" in its name...

Better look for UI elements relative to fileUpload or Office integration or for tools like CL_WD_RUNTIME_SERVICES  ?

Regards,

Raymond

[Former Member]

thanks.I find the CL_WD_RUNTIME_SERVICES and see the method ATTACH_FILE_TO_RESPONSE":

method attach_file_to_response.

   wdr_task=>client_window->client->attach_file_to_response(

     i_filename      = i_filename

     i_content       = i_content

     i_mime_type     = i_mime_type

     i_in_new_window = i_in_new_window

     i_inplace       = i_inplace ).

endmethod.

i want to know where to save the content of my file?

[POV8FE]

Hallo Zhiyu,

can you try to debug using "external debugging" ?

Utilities / Settings, tab ABAP-Editor / Debugging enter the User calling the RFC Module.

and / or try to set a external breakpoint in your coding.

Bye, Volker

[Former Member]

the codes can be execute complletely in the backend,and I can't debug it while it run in web.....
how to using "external debugging" ?

[POV8FE]

Found a nice description here:

But Raymond seems to have more specific experience with this function modules ??

What you wrote: "I also try to use 'GUI_UPLOAD' but it shows "gui_refuse_filetransfer ".

irritates.

Also curious about the solution.

BYe, Volker