Error during import of clipboard contents

[JaspherRivera]

Using FM: ALSM_EXCEL_TO_INTERNAL_TABLE, we tried to execute the program in background, but we encountered this error "Error during import of clipboard contents".

When we run it in foreground, it is working normally. may we know what would be the resolution for this?

[Sandra_Rossi · Accepted solution]

As already answered in the forum many times, this function module can't work in background, because it's based on OLE to connect to the Excel application installed on the user's laptop, and in background it's impossible to connect to the user's laptop (like e.g. impossible to use GUI_UPLOAD, etc.)

Depending on the Excel file format, there are several workarounds:

• If it's a text format like CSV or tab-separated fields, you may upload the file to the application server before running the job, and you use OPEN DATASET, READ DATASET, etc. to read the text lines and fields.
• For other formats, you may use any solution like abap2xlsx or XCO for XLSX format, custom XML transformations if it's an XML-like format, etc.