topic Re: Reading Excel file while running in background in Application Development and Automation Discussions

Reading Excel file while running in background

eyal_alsheikh — Wed, 22 Jun 2005 07:33:10 GMT

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.

Re: Reading Excel file while running in background

christian_wohlfahrt — Wed, 22 Jun 2005 07:57:54 GMT

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

Re: Reading Excel file while running in background

eyal_alsheikh — Wed, 22 Jun 2005 08:14:28 GMT

Hi Christian,

My Excel file extension is .xls .

Thanks,

Eyal.

Re: Reading Excel file while running in background

christian_wohlfahrt — Wed, 22 Jun 2005 08:36:34 GMT

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

Re: Reading Excel file while running in background

krzysztof_konitz4 — Wed, 22 Jun 2005 09:27:04 GMT

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