Java Apache POI reading empty column after row data column

Question

I have 100 rows 10 columns. reading each row one by one and column also. After 10th column the cursor not moving into next row. It's going to 11 12 13 etc column. Could anyone help me how to move the next row once reading 10th column and how to stop reading empty 11 column.

Here is some code:

while (rowIterator.hasNext()) { 
    row = rowIterator.next(); 
    while (cellIterator.hasNext()) { 
        cell = cellIterator.next(); 
        if(cell.getColumnIndex()==0 ) { } 
        ..... 
        if(cell.getColumnIndex()==10) { } 
    }
}

Can you describe a bit more and include some code-snippets of what you are trying to do? — centic
– centic, Commented Dec 22, 2016 at 8:03
while (rowIterator.hasNext()) { row = rowIterator.next(); while (cellIterator.hasNext()) { cell = cellIterator.next(); if(cell.getColumnIndex()==0 ) { } ..... if(cell.getColumnIndex()==10) { } } In the above code am iterating each cell. after 10th cell I have empty columns. those empty columns are iterating But I want to move into next row after 10 cell and stop reading the empty cells like 11,12,13 etc. — Siva Kumar
– Siva Kumar, Commented Dec 22, 2016 at 9:01

jmarkmurphy · Accepted Answer · 2016-12-22 14:05:26Z

1

First, but this will not necessarily fix your problem, you should be using the for each syntax to iterate rows and columns, then once you get past column 10 you can just break out of the loop like so:

for (Row row : sheet){
    for (Cell cell : row) {
        ...
        if (cell.getColumnIndex() >= 10) break;
    }
}

This is documented in the POI Quick Guide here: https://poi.apache.org/spreadsheet/quick-guide.html#Iterator

NOTE: I am breaking when column index is 10 or greater (that would be the 11th column as the indexes are 0 based). I mention this only because your code example is using column indexes 0 - 10, but your text says that there are only 10 valid columns.

answered Dec 22, 2016 at 14:05

jmarkmurphy

11.6k37 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DevMateus · Accepted Answer · 2022-08-25 18:43:37Z

0

if you want to skip column you can use

while (cellsInRow.hasNext()) {
     Cell currentCell = cellsInRow.next();

     if (currentCell.getColumnIndex() >= 3 && currentCell.getColumnIndex() <= 6) {
         continue;
     }
         }

to skip column 4, 5, 6 and 7 from excel file. index starts at 0

answered Aug 25, 2022 at 18:43

DevMateus

3011 silver badge7 bronze badges

Collectives™ on Stack Overflow

Java Apache POI reading empty column after row data column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related