Page 1 of 1
How to read from an excel sheet in linux?
Posted: Wed Jul 07, 2010 2:46 am
by karry450
Hi Friends
Can anyone help me
How to read from an excel sheet in linux?
are there any ODBC drivers for free available
Thanks
Posted: Wed Jul 07, 2010 3:15 am
by ArndW
There are quite a few out there, my google search for "free LINUX Excel ODBC driver" returned over 70,000 pages. I haven't had to use any in production so couldn't recommend any particular one. The easiest way would be to use a .csv format for the Excel sheet - that way it can be processed in Excel and read by the standard text ODBC drivers available for free on all systems.
I just recalled that I read about the OpenOffice ODBC drivers for excel - those would certainly work well.
Posted: Wed Jul 07, 2010 3:46 am
by venugopal.123
For reading Excel files one stage is there i.e. Java client stage this stage is not included in the Datastage your company need to buy this stage from IBM...
Posted: Wed Jul 07, 2010 4:17 am
by ArndW
DataStage supports ODBC and there are various drivers out there, either one can buy it from IBM, another software vendor, or use free software for LINUX.