Error while executing function "ALSM_EXCEL_TO_INTERNAL_TABLE" in Netweaver Gateway Odata

[#1]

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,Have you guys ever met this problem? Please show me the the solution, or guide me how to fix this error.

Thanks in advance!!!!

[EkanshCapgemini]

Hi,

Please explain your use case.

As per my understanding, you want to upload some excel sheet with data and data will be extracted from that sheet and processed afterwards. If this is the case, you can not use ALSM_EXCEL_TO_INTERNAL_TABLE to convert the excel into internal table because in the backend you will be getting the XSTRING of xls which can not be converted by this FM. For this scenario, CSV file will be helpful. Check this link

Regards,

Ekansh