You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by Jonathan Cowherd <jo...@genscape.com> on 2003/06/05 16:50:25 UTC
HSSFSheet error when creating
When I load the attached file, I get a bizarre exception, which I can't
explain. It lools like it attempts to set Properties from some sheets
(which I don't care about, just data).
<code>
public HSSFWorkbook loadFile(String file) {
HSSFWorkbook iworkbook = null;
try {
InputStream idocument = new FileInputStream(file);
log.debug("File exists, reading...");
POIFSFileSystem idata = new POIFSFileSystem(idocument);
log.debug("File " + file + " read.");
iworkbook = new HSSFWorkbook(idata);
log.debug("Excel Workbook found.");
idocument.close();
} catch (FileNotFoundException e) {
log.fatal("File " + file + " can not be found.");
} catch (IOException e) {
e.printStackTrace();
log.fatal("File or workbook " + file + " can not be read.");
}
return (iworkbook);
}
</code>
java.lang.NullPointerException
at
org.apache.poi.hssf.usermodel.HSSFSheet.setPropertiesFromSheet(HSSFSheet.jav
a:171)
at
org.apache.poi.hssf.usermodel.HSSFSheet.<init>(HSSFSheet.java:134)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:154)
at
com.genscape.fieldloader.AbstractFieldLoader.loadFile(AbstractFieldLoader.ja
va:68)
at
com.genscape.fieldloader.UnitDataSheetFieldLoader.loadUnitDataFile(UnitDataS
heetFieldLoader.java:50)
at
com.genscape.fieldloader.UnitDataSheetFieldLoader.main(UnitDataSheetFieldLoa
der.java:60)
Exception in thread "main"
Should I attempt to force an encoding? Can I bypass that step?
Jonathan Paul Cowherd
Linux and Java Administrator
Genscape, Inc.
Email: jonathan.cowherd@genscape.com
Office: (502) 583-3730
Mobile: (502) 314-0444