topic Error in Function Module TEXT_CONVERT_XLS_TO_SAP in Application Development and Automation Discussions

Error in Function Module TEXT_CONVERT_XLS_TO_SAP

Former Member — Tue, 21 Mar 2017 09:35:18 GMT

HI All,

I tried to execute the function module "TEXT_CONVERT_XLS_TO_SAP" in SE37. But it gives me one error "Error generating the test frame" . I have attached the screen shot. If there is any other function module that converted the EXCEL File in SAP please inform me.

Thanks in advance.

Re: Error in Function Module TEXT_CONVERT_XLS_TO_SAP

RaymondGiuseppi — Tue, 21 Mar 2017 10:14:42 GMT

Have a look at a FM like ALSM_EXCEL_TO_INTERNAL_TABLE. There are restrictions on this one (933420 - ALSM_EXCEL_TO_INTERNAL_TABLE) but that a good sample if you never used OLE in Abap.

You shoud really perform some search as there are nowadays many many threads/discussions/wiki on how to upload Excel data in Abap, especially in background when OLE or Excel are not available...