How to read from an excel sheet in linux?

karry450 · Post by **karry450** » Wed Jul 07, 2010 2:46 am

Hi Friends

Can anyone help me

How to read from an excel sheet in linux?

are there any ODBC drivers for free available

Thanks

ArndW · Post by **ArndW** » Wed Jul 07, 2010 3:15 am

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.

venugopal.123 · Post by **venugopal.123** » Wed Jul 07, 2010 3:46 am

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...

ArndW · Post by **ArndW** » Wed Jul 07, 2010 4:17 am

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.