Iterate the data over row and cell in POI API

Java APIS

In this page of the example we are going to show you how we can iterate the data over row and cell.This is possible with a simple for loop. Luckily, It is very easy. Row defines a CellIterator inner class to handle iterating over the cells (get one with a call to row.cellIterator()), and Sheet provides a rowIterator() method to give an iterator over all the rows. Alternately, Sheet and Row both implement java.lang.Iterable, so using Java 1.5 you can simply take advantage of the built in "foreach" support.

 


Workbook wkb=new Workbook();
    sheet shit = wkb.getsheetat(0);
    for (iterator<row> rit = sheet.rowiterator(); rit.hasnext(); ) {
      row row = rit.next();
      for (iterator<cell> cit = row.celliterator(); cit.hasnext(); ) {
        cell cell = cit.next();
        // Write next code here which you want
      }
    }