In 1.2.0 there is an easier way to do this. If you use the new eventmodel API you can just catch the cells and ignore any that you're not interested.
Just to give you an idea... What takes 80mb currently, takes only 7mb with the eventmodel API. Once we move to jakarta, I'm going to push for an interim release. -Andy On Tue, 2002-01-29 at 03:15, [EMAIL PROTECTED] wrote: > I didn't download 1.2.0, however when I removed the > graphs, the problems disappeared. > > I think that solves pretty much all of my current > problems, although I do have one more question. > > Is there any easy way to work with columns, instead of > rows? For example, say I have a big sheet full of data > (such as the one I uploaded as a problematic sample, > less the graphs of course) and I wanted to write a > program that would calculate the average of every > single column, and add it to the bottom of the column. > I would think that if this sheet were organized such > that instead of having columns of data, it had rows, I > could just go through a HSSFRow's cells, and average > them. With a column, I need to access a different row > every time I want to move down in the column. Is there > an easier way to do this? > > Thanks again for all the help, > Russell Stadler > > "Andrew C. Oliver" wrote > > > > > Assigning Glen to look at this. The sample has > embedded graphs. > > > > Tested with reasonably recent build and it still > failed. > > > > Russell, > > > > POI::HSSF 1.0.2 will not handle embedded graphs, they > are treated as > > separate sheets within sheets and it has no idea what > to do with them. > > Glen has new code to handle graphs in the current > development build. > > > > Download the latest development build and try them > with it. I'll do so > > shortly, but I don't have time to finish right now > (meeting someone). > > > > If you remove the graphs it should work fine. > Regardless this shouldn't > > throw an exception (at the very least) in the latest > development build. > > > > ccing glen. > > > > -Andy > > > > On Mon, 2002-01-28 at 12:12, [EMAIL PROTECTED] > wrote: > > > Hello again, > > > > > > My apologies for the inadequate information. The > > > version of POI is 1.0.2. I thought it was all .xls > > > files, however it turns out I am mistaken. I had a > > > number of sample files I was working with, which > were > > > all files that had been exported from Radview's > WebLoad > > > software. When I filled in a few cells manually in > > > > sheet, it worked fine. > > > > > > I've uploaded both the .xls I created, and one of > the > > > .xls files that failed http://www.qxfr.com/poi. The > > > one that works is named ok.xls, the other is named > > > problem.xls > > > > > > Based on what you've said, I think it's either 1 or > 2. > > > I can view the workbook in Excel (2000) fine, so I > > > think that it's not a result of number 3. It could > be > > > a result of 4 or 5, but I'm doubtful, because it did > > > work fine with the workbook I just filled a little > with > > > gibberish. > > > > > > I don't know how I would check if the XLS files are > > > encrypted or not in proper format. Additionally, I > > > would like to know if it is possible to unprotect a > > > file, or convert it into proper excel format. > > > > > > If it's at all helpful, I uploaded the source to a > > > little test program that reproduces this problem > with > > > the problem.xls file. > > > > > > Thanks for your help, > > > Russell Stadler > > > > > > > > > "Andrew C. Oliver" wrote > > > > > > > > > > > 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 > > > > > > > > > > > > ------------------------------------------ > > > [EMAIL PROTECTED] > > -- > > 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 > > > > ------------------------------------------ > [EMAIL PROTECTED] -- 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
