excel upload in background not working

[Former Member]

Greetings,

I have used 2 functions, ALSM_EXCEL_TO_INTERNAL_TABLE and TEXT_CONVERT_XLS_TO_SAP. Both work when run online, but fail in background. What I am reading suggest that the excel must be converted first to a txt (tab-delimited). Is this correct or is there another function that will work without the conversion?

Thanks.

[Former Member]

Hi,

I don't think function module ALSM_EXCEL_TO_INTERNAL_TABLE is designed to run in the background as it uses OLE (object link enabling) to communicate with the frontend.

As there's no frontend attached to a background process, it won't work in this situation.

Regards,

Nick

[JozsefSzikszai]

hi Richard,

the above mentioned FMs work only in foreground. The reason for this is that they communicate with Excel implemented on the presentation server on your machine during the upload. In background, there is no presentation server, so no Excel communication possible, so no successfull upload. You have to for another solution, the one you mentioned (tab delimited text file) could be a good way.

hope this helps

ec