Hi-
Is DataStage capable of creating an actual MS Excel File - not a CSV file, an actual MS Excel File. Please note, our DataStage server is deployed on UNIX, not Windows.
Alternatively if DataStage is not capable of creating an Excel file, but I have an Excel template, is it possible to open it and populate it with data?
Thanks!
Create Excel File
Moderators: chulett, rschirm, roy
No, DataStage cannot create and write the MS-Excel file format on UNIX. There are ways to do this, but all involve purchasing extra software.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
ArndW - In your reply above, is the 'extra software' you're referring to the Excel ODBC driver from Microsoft?
The reason I'm asking is that I'm needing to do the exact thing the OP refers to, which is adding data to an existing Xcel template. I know this topic gets brought up from time to time, but I haven't found a lot of real detail concerning it. Thanks in advance!
Tom
The reason I'm asking is that I'm needing to do the exact thing the OP refers to, which is adding data to an existing Xcel template. I know this topic gets brought up from time to time, but I haven't found a lot of real detail concerning it. Thanks in advance!
Tom
Perl has methods for reading and writing native .xls files. I've used the read method in conjunction with a different ETL tool, but calling a perl script in a before/after routine should work just fine with DataStage.
A google search on Spreadsheet::WriteExcel or Spreadsheet::ReadExcel should help.
Mike
A google search on Spreadsheet::WriteExcel or Spreadsheet::ReadExcel should help.
Mike