>On Wed, 27 Feb 2002 19:04:08 0100 "Reto Badertscher" <[EMAIL PROTECTED]> wrote. >Hello, > >just started using POI for reading, writing and modifying Excel sheets and >like it very much. Until now i've been using Perl libraries for these tasks. >During creating some test applications i encountered the following problem: >When a HSSFRow has empty cells the method 'getPhysicalNumberOfCells()' >returns the number of cells with values and the method
That is correct behavior 'getLastCellNum()' >returns 0, regardless of the number of cells. According to my understanding >it should return the number of the last cell containing a value - or do i >missing something? Nope.. This is a known bug. I believe Glen has fixed it (Glen?) and it should be in the next production release (1.5) soon. You could also use the CVS edition. I'd suggest you investigate using the event based API for reading. Although it is more *difficult*, it is far more efficient by some order of 10 as far as memory goes. -Andy >Version: 1.0.2 >JDK: 1.3.1_01 >Platform: Windows 2000 SP 2 > >Thanks for any help > >Reto >
