How to get column value from excel in JAVA?

Question

How can i read for each row and cloumn 14 value into string variable in apache poi 4.

         while (rows.hasNext()) {
                Row currentRow = rows.next();
                System.out.println(currentRow);
                Iterator<Cell> cellsInRow = currentRow.iterator();
                while(cellsInRow.hasNext()) {
                    Cell currentCell = cellsInRow.next();
                    int cellIndex = currentCell.getColumnIndex();
                    int columnidx = 14;
                    String values = currentCell.getStringValue() //how can i get the  value for every row for column 14  
                }
            }

Andreas · Accepted Answer · 2020-10-30 14:59:58Z

If you look at the documentation, i.e. the javadoc of Row, you will find the very handy getCell(int cellnum) method:

Get the cell representing a given column (logical cell) 0-based. If you ask for a cell that is not defined....you get a null.

Which means you shouldn't iterate all the cells:

while (rows.hasNext()) {
    Row currentRow = rows.next();
    Cell cell14 = currentRow.getCell(13); // 14th cell
    String value = (cell14 == null ? null : cell14.getStringCellValue());
    // use value here
}

Unrelated, but you shouldn't use iterator while loops. The code will be simpler and easier to read if you use a for-each loop, so instead of:

Iterator<Row> rows = sheet.rowIterator();
while (rows.hasNext()) {
    Row currentRow = rows.next();

    Iterator<Cell> cellsInRow = currentRow.iterator();
    while (cellsInRow.hasNext()) {
        Cell currentCell = cellsInRow.next();

    }
}

you should use:

for (Row currentRow : sheet) {

    for (Cell currentCell : currentRow) {

    }
}

See how much that improves the code?

Collectives™ on Stack Overflow

How to get column value from excel in JAVA?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related