Exception while reading xlsx file
Hi,
My xslx file low has 7,00,000 records. While i am reading a file i get below exception
jxl.read.biff.BiffException: Unable to recognize OLE stream
at jxl.read.biff.CompoundFile.<init>(CompoundFile.jav a: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 west.lpa.applications.lightweightupdater.XlsReader .read(XlsReader.java:67)
at west.lpa.applications.lightweightupdater.XlsReader .main(XlsReader.java:107)
What is the fix for this issue??
Re: Exception while reading xlsx file
Hello tcstcs,
I have moved this thread to - Java Programming Forums - Exceptions
Is this what you are using? A Java API to read, write and modify Excel spreadsheets
What version of Excel are you using?
Quote:
Reads data from Excel 95, 97, 2000 workbooks Reads and writes formulas (Excel 97 and later only) Generates spreadsheets in Excel 2000 format
If your documents were created using a version of Excel not supported, I suggest looking into Apache POI.
