Hi!

I am using the row iterator of apache POI for reading all the lines the user
write, work with that data, and fill a database.

I am doing:

*
//I. Create the row iterator for iterating over every circuit registry
final Iterator<Row> rows = sheet.rowIterator();
                
//II. Skip the titles line
rows.next();
        
//III. Iterate over each new row...
while (rows.hasNext()) {

      //inside the while i make some stuff...

}
*

I have, for example, 1 title row and 3 registers in the first 4 rows of a
sheet, and no more data.

The problem is there are many cases in which hasNext() method is saying me
that are new rows when I have finished of reading the third register, and
jump to an not edited "alleatory" row (row 46, row 52, etc...)...

The excel has validations rules in almost every cell...¿can this be the
reason of this anormally behaviour of the hasNext method?

Any idea?

Thank you in advance!




--
View this message in context: 
http://apache-poi.1045710.n5.nabble.com/Error-detecting-last-edited-row-tp5712664.html
Sent from the POI - Dev mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to