How to read excel file in Datastage

[anand_dafaria]

Hi All,

I am facing problems while reading excel file in Datastage Px in Unix environment.

I have tried doing it using sequential file stage, but it is not able to read the data.
If am I converting it into csv file (manually) then I am able to do read it.
But we will be getting pleanty of such source files. So can not do it manually.

My questions are ---
1. Can we read Excel files in Datastage on Unix platform?
2. If no, then how to convert excel files into Csv format in Datastage.

Can anyone help me...

Regards
Anand

[ray.wurlod]

Doesn't the DSXchange Search facility work for you?

This question has been asked, and answered, on more than a few occasions.