How can we create an .xls file in Datastage

tanaya.deshpande@tieto.co · Tue Mar 22, 2011 2:24 am

How can we create an .xls file in Datastage??

iHijazi · Post by **iHijazi** » Tue Mar 22, 2011 2:55 am

You first need Excel ODBC driver installed (installed on most machines, Windows machines with MS Office).

Once confirmed, use the ODBC stage and start the magic!

samyamkrishna · Post by **samyamkrishna** » Tue Mar 22, 2011 2:56 am

you can create a .csv file which will open in excel

Ravi.K · Post by **Ravi.K** » Tue Mar 22, 2011 3:14 am

Heads up, XLS file has limitation of Rows(65535).

chulett · Post by **chulett** » Tue Mar 22, 2011 6:55 am

That would depend entirely on the version. And as noted, you're much better off creating a simple csv file which Excel will happily (and automatically) open and convert.

DSXchange

How can we create an .xls file in Datastage

How can we create an .xls file in Datastage

Re: How can we creat a .xls file in Datastage