I have the excel file with well over 4500 rows and just 7 columns.
When I read it at row 3524 the count of columns changes to just 6.
I don't understand why? It's always 7. I've noticed that my third column at
that row
doesn't have anything in there but I'm checking for the blank cells and if
there's one I deal with it.
The problem is that the blank one is simply skipped and only 6 column read.
This isn't obviously right
because from that point on all of my data will be misaligned.
It looks like the cells = row.cellIterator(); isn't really working right.
Here is a simplified version of my code. Any clues?
Iterator cells = null;
while(rows.hasNext()){
//I do some stuff here
XSSFRow row = (XSSFRow) rows.next();
cells = row.cellIterator();
while(cells.hadNext()){
//I do some stuff here.
}
}
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Coumn-miscount-tp3425833p3425833.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
