Reading Excel file while running in background

[eyal_alsheikh]

Hi,

I need to save content of my Excel file in internal table

while running my program in background mode.

My Excel file is stored in the application server folder.

I tried to use open,read,close dataset both in binary mode and text mode but I gets gibberish.

Thanks for any ideas,

Eyal.

[eyal_alsheikh]

Hi,

I need to save content of my Excel file in internal table

while running my program in background mode.

My Excel file is stored in the application server folder.

I tried to use open,read,close dataset both in binary mode and text mode but I gets gibberish.

Thanks for any ideas,

Eyal.

[christian_wohlfahrt]

Hi Eyal!

Is your excel file in internal format (.xls) or is it an .csv (comma separated values)?

.csv should work in text mode, internal (.xls) format would need a special import filter. These filters I only know for online use.

Regards,

Christian

[eyal_alsheikh]

Hi Christian,

My Excel file extension is .xls .

Thanks,

Eyal.

[christian_wohlfahrt]

Hi Eyal!

Any chance to get a file conversion by Excel?

Otherwise have a look at program SAPRDEMOEXCELINTEGRATION (transaction DWDM) and check, if some parts work in background (and application server), too.

Regards,

Christian

[krzysztof_konitz4]

Hi,

To read xls file you need controls which are part of excel

installation. I don't think that you installed excel on your BW server...

Krzys