What version of POI is this? 1.0.2 or 1.2.0. Please provide a sample xls if possible. This is not really sufficient data? Is it ONLY on this XLS or on all XLS?
Here are some wild guesses 1. The sheet is "protected" (which is a Microsoftism for encrypted) 2. The sheet is not in (proper) Excel 97 format (For example StarOffice 5.1 creates basically a cross-hybrid between 97 and 95 format...which Excel 97 can read but later versions of Excel officially cannot and HSSF ONLY plans to support 97+) 3. The Workbook is invalid 4. you've stumbled upon something HSSF doesn't support (in which case a sample would be REALLY appreciated) 5. There is a bug in HSSF that you've uncovered (see #4). In any case a sample XLS or more information would be awesome! -Andy On Mon, 2002-01-28 at 00:02, [EMAIL PROTECTED] wrote: > Hello, > > When executing the line > > HSSFWorkbook workbook = new HSSFWorkbook(poifs); > > with poifs being an existing POIFSFileSystem created > from an inputstream, I recieve the following exception: > > ---------------------------------------------------- > java.lang.NullPointerException > > at > >net.sourceforge.poi.hssf.usermodel.HSSFSheet.setPropertiesFromSheet(HSSFSheet.java:184) > > at > net.sourceforge.poi.hssf.usermodel.HSSFSheet.<init>(HSSFSheet.java:142) > > at > net.sourceforge.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:159) > ---------------------------------------------------- > > Any help would be greatly appreciated. > > -Russell Stadler -- www.superlinksoftware.com www.sourceforge.net/projects/poi - port of Excel format to java http://developer.java.sun.com/developer/bugParade/bugs/4487555.html - fix java generics! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh
