Maximum number of columns?

[sjakiePP]

Dear all,

Is there a maximum number of columns I can retrieve from an excel sheet? I am using Selenium with Excel through an ODBC connection. When I get to columnnr 256, my program just stops. No warning or exception is given.

I'm using jdk1.7.0_03 with Excel driver version 12.

If there is a limit, what are good alternatives? Something like Apache POI?

Thanks in advance.

With kind regards,
Sjakie

---------------------------------------------
Yes, the world is full of strange people.

 

[TonHu]

Apache POI is indeed a good alternative for reading Excel, and I'd expect it to be much faster than JDBC too.

I'd expect the 256 column limit be related to the JDBC driver you are using.

 

[sjakiePP]

Thanks for your reply.

POI is faster indeed. Now I have converted my script to use POI and it works very fast. Also it showed I had some errors in my code, which are now fixed...

---------------------------------------------
Yes, the world is full of strange people.

 

[TonHu]

Great!