This week's book giveaway is in the Agile and other Processes forum. We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line! See this thread for details.
How to read excel2007 file or both .xls and .xlsx files using apache poi
harini veerapur
Greenhorn
Joined: Jun 29, 2010
Posts: 9
posted
0
Dear sir,
How to read a .xlsx files using poi ,i am able to read only .xls files using poi and if i read a .xlsx file it throws an exception so give me some sample code to read both .xls and .xlsx files using poi .
Thanks........
Ulf Dittmer
Marshal
Joined: Mar 22, 2005
Posts: 35252
7
posted
0
Note that POI versions before 3.5 do not support XSLX.
If you are, in fact, using a POI version that does support XLSX, post the code you're using. Knowing what exception is thrown would also be useful.
The HSSF* classes are for working with XLS files, not XLSX. There are other classes (in some package called *.ss.*) that work with both formats; the POI documentation has the details on that.