Reading Excel 2003 at Background Job

[former_member457651]

Dear:

I try to search the answer for old post but cannot find a solution for reading Excel 2003 at background job.

Actually, I am making a RFC BAPI call by XI to read an excel file.

The BAPI is working when running at front-end but fail if I call in run at background program.

I already try function module ALSM_EXCEL_TO_INTERNAL_TABLE and KCD_EXCEL_OLE_TO_INT_CONVERT but both are not working.

Since Excel 2003 is not XML, is anyway I can read the excel at background?

Thank you.

[Former Member]

hi,

try the function module

TEXT_CONVERT_XLS_TO_SAP

it will help to resolve the issue

thanks

sarvesh

[former_member457651]

Thanks for the reply.

I already tried that function and force the program to run even in background mode,

however, the job will be cancel due to

"Control Framework: Fatal error - GUI cannot be reached".

[mvoros]

Hi,

why can't you convert xls file into csv file and then read is as normal text file? All those FM like TEXT_CONVERT_XLS_TO_SAP use OLE for integration with Excel. Hence it will not work without GUI.

By the way Office 2003 supports XML as an output format for Excel.

Cheers

[Former Member]

Hi,

Create varient with correct path and select varient while sheduling background. If working program in foreground correct then if should be work. Check properly.

Regards

Md.MahaboobKhan