HI,
Is there prerequisites to extract excel files?
I am using unix based DS 9.1 version. Client is windows 7. I installed excel 2010 in client version. I am able too see the data in windows. I moved the file to unix machine through winscp. I am trying to extract the data using unstructured data stage. I mentioned filename along with filepath. i tried with range options as specify start row and specify the data range. range expressions. Column header. I tried with xls and xlsx formats.
Im getting error "file doesnot exist. Specify a valid file name".
Do i need to install or configure any library functions? Please guide.
You don't need to add any components to get this to work. I do recall that I had issues with parameter values inside the unstructured data stage; and you need to remember that paths used in this stage are relative to the server, not your DataStage client workstation.
- DataStage Server is installed on which flavor of Unix?
- Was the WINSCP file transfer of excel file done in Binary mode?
- In Unstructured Data Stage, is the path and the excel filename hard-coded Or is it parameterized?
</a>