Excel 2007(.xlsx) Reading code using POI 3.5 in java?

Question

Hi,

I have downloaded latest POI version 3.5. I want to read the Excel file (.xlsx format) using the POI.

If anybody has any Example source code or any URL or any other code snippet which can read the Excel file (.xlsx format) using the latest version of POI,which would be appreciated.

Thanks,

Mishal Shah

Answer 1

Hi, Here is the XLSX to CSV Converter example for POI, and you can dig into svn for more examples here

Answer 2

Have a look at SmartXLS for Java.

It is a third party Excel component which can read/write Excel2007 files and support most excel features like Chart,Formula,Pivot table...etc.