When opening and Excel file I get this exception: java.lang.NullPointerException at org.apache.poi.hssf.usermodel.HSSFSheet.setPropertiesFromSheet (HSSFSheet.java:171) at org.apache.poi.hssf.usermodel.HSSFSheet.<init>(HSSFSheet.java:134) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init> (HSSFWorkbook.java:154) at gtisoft.ms.excel.ExHandler.open(ExHandler.java:45) The code that produces the error is: public HSSFWorkbook open(File f) throws FileNotFoundException, IOException { if (isOpened()) { close(); } _fStream = new FileInputStream(f); _buffStream = new BufferedInputStream(_fStream); POIFSFileSystem fs = new POIFSFileSystem( _buffStream ); _wb = new HSSFWorkbook(fs); return _wb; } I don't know how to attach the excel file here, can you show me how to do it?. If it can't be done I'd be more than happy to email it to you. I have downloaded and tested opening this file with POI 2.0-RC1 and it works correctly. At the current stage of my project I can't move to POI 2.0.
Created attachment 9379 [details] Excel file that can't be opened
Works as of 12Jan2007, Testcase added. http://issues.apache.org/bugzilla/show_bug.cgi?id=41366