Problem with reasing excel file

[Dimitri Vettenburg <Di...@skynet.be>]

Hi,
 
I am using POI1.09 and I am having problem with reading an excell file.
 
The program I have written is in a try catch block, catching a
nullpointerexception.
 
The purpose of the nullpointerexception catch is to stop reading from
the excel file when an null row is read.
 
It seams now that, although I have more than 35 lines in the spread
sheet, the application is telling me that row 32 (always the same one)
is null, and thus stopping from reading further on.
 
I have the impression that the program only has read in the first 32
rows of the spread sheet and as a result is returning the
nullpointerexception. How do I force the program to read more lines into
memory?
 
 
KR,
 
 
Jan

Re: Problem with reasing excel file

["Andrew C. Oliver" <ac...@apache.org>]

The solution is simple.  There is no row 32.  Use the iterators and just get
the rows that are there.

-Andy

On 5/25/03 7:46 AM, "Dimitri Vettenburg" <Di...@skynet.be>
wrote:

> Hi,
> 
> I am using POI1.09 and I am having problem with reading an excell file.
> 
> The program I have written is in a try catch block, catching a
> nullpointerexception.
> 
> The purpose of the nullpointerexception catch is to stop reading from
> the excel file when an null row is read.
> 
> It seams now that, although I have more than 35 lines in the spread
> sheet, the application is telling me that row 32 (always the same one)
> is null, and thus stopping from reading further on.
> 
> I have the impression that the program only has read in the first 32
> rows of the spread sheet and as a result is returning the
> nullpointerexception. How do I force the program to read more lines into
> memory?
> 
> 
> KR,
> 
> 
> Jan
> 

-- 
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI

http://jakarta.apache.org/poi
For Java and Excel, Got POI?