topic Re: Error while executing function "ALSM_EXCEL_TO_INTERNAL_TABLE" in Application Development and Automation Discussions

Error while executing function "ALSM_EXCEL_TO_INTERNAL_TABLE"

Former Member — Fri, 28 Nov 2014 07:39:58 GMT

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.

Re: Error while executing function "ALSM_EXCEL_TO_INTERNAL_TABLE"

RaymondGiuseppi — Fri, 28 Nov 2014 07:48:19 GMT

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

Re: Error while executing function "ALSM_EXCEL_TO_INTERNAL_TABLE"

VolkerProebius — Fri, 28 Nov 2014 07:48:29 GMT

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

Re: Error while executing function "ALSM_EXCEL_TO_INTERNAL_TABLE"

Former Member — Fri, 28 Nov 2014 07:55:20 GMT

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 ".

Re: Error while executing function "ALSM_EXCEL_TO_INTERNAL_TABLE"

Former Member — Fri, 28 Nov 2014 08:04:19 GMT

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" ?

Re: Error while executing function "ALSM_EXCEL_TO_INTERNAL_TABLE"

RaymondGiuseppi — Fri, 28 Nov 2014 08:05:00 GMT

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

Re: Error while executing function "ALSM_EXCEL_TO_INTERNAL_TABLE"

VolkerProebius — Fri, 28 Nov 2014 08:18:46 GMT

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

Re: Error while executing function "ALSM_EXCEL_TO_INTERNAL_TABLE"

Former Member — Fri, 28 Nov 2014 09:29:22 GMT

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?