How to read excel file in Datastage
Posted: Tue Apr 13, 2010 11:42 pm
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
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