Link to home
Start Free TrialLog in
Avatar of sangameshrh
sangameshrh

asked on

Reading from Excel 2007 (.slsx) file in JAVA

I want to read from a Excel 2007 (.xlsx f) file in JAVA

Thanks
Avatar of CEHJ
CEHJ
Flag of United Kingdom of Great Britain and Northern Ireland image

Try POI HSSF - but i'm not sure if it supports that version
ASKER CERTIFIED SOLUTION
Avatar of Mick Barry
Mick Barry
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sangameshrh
sangameshrh

ASKER

When I try with JExcel 2.6.6 I am getting this error
--------------------Configuration: <Default>--------------------
jxl.read.biff.BiffException: Unable to recognize OLE stream
    at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
    at jxl.read.biff.File.<init>(File.java:127)
    at jxl.Workbook.getWorkbook(Workbook.java:221)
    at jxl.Workbook.getWorkbook(Workbook.java:198)
    at Test.<init>(Test.java:12)
    at Test.main(Test.java:38)

Process completed.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
> When I try with JExcel 2.6.6 I am getting this error

doesn't support that version, as I mentioned above most (if not all) won't yet.
You'll need to save it as an earlier version, or try using jdbc.