Get the below exception when reading the attached excel. org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:186) at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:328) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:271) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:196) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:178)
Please post the problem file, along with the full stacktrace so we can see which record it's unable to open Also, please confirm if you've tried with a recent svn checkout / nightly build?
Hi Nick, Thanks for the prompt response. Actually, the file was created as XLS with MS Office. If we open the file with MS Office and then save it as XLSX and then again convert the XLSX file to XLS with open OpenOffice, the POI is having no issues in reading that document(XLS file). But POI is failing to read the document directly, as mentioned earlier. I am not able to understand why this is happening, There is no change in the document contents after saving it as XLS with OpenOffice. Thanks & Regards, Pankaj Dubey Software Engineer Team Live Documents | InstaColl, Bangalore Contact: pankaj@instacoll.com | +91-9916129921
Please attach the problematic file. Without it we can't do much to help you. Yegor
no response in a long time => resolving for now, please reopen with more information ifnthis is still an issue