Re: Reading an excel spreadsheet with RPG and hssfr4

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

I'm looking at the documentation for the HSSFSheet class and it has a 
method named 'getLastRowNum'.  I haven't tried it, but it sounds like 
what you're looking for.... might be worth a shot.

http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFSheet.html

In my opinion, the best way to red the entire file is to use the event 
model (rather than the user model that you're attempting to use). 
However, the event model doesn't let you make updates to the sheet, so 
it's probably not useful to you. (In a private e-mail, you told me you 
wanted to update it -- though you didn't mention it on RPG400-L)

HTH


Jason Pennybacker wrote:

> Is there a way to find out how many rows are in the sheet so that you
> can read the entire file or is there a better way to read the entire file?
>
> Jason Pennybacker
> i5 Programmer
> RateWatch
> (P) 1.800.348.1831 ext 313
> (F) 1.920.568.1402
> www.rate-watch.com