Apache POI Reading Cell Content

by Online Tutorials Library July 14, 2022

Apache POI Reading Cell Content

Apache POI Reading Cell Content Example

  package poiexample;  import java.io.FileInputStream;  import java.io.InputStream;  import org.apache.poi.ss.usermodel.Cell;  import org.apache.poi.ss.usermodel.Row;  import org.apache.poi.ss.usermodel.Sheet;  import org.apache.poi.ss.usermodel.Workbook;  import org.apache.poi.ss.usermodel.WorkbookFactory;  public class GettingCellContentExample {  public static void main(String[] args) {  try (InputStream inp = new FileInputStream(“tutoraspire.xls”)) {          Workbook wb = WorkbookFactory.create(inp);          Sheet sheet = wb.getSheetAt(0);          Row row = sheet.getRow(2);          Cell cell = row.getCell(3);          if (cell != null)          System.out.println(“Data: “+cell);          else              System.out.println(“Cell is empty”);      }catch(Exception e) {      System.out.println(e);      }  }  }  

This is our spreadsheet file to that we want to read.

After executing the above example, it reads the value from specified cell and produce the following output to the console.

Output:

Data: 200.0

Next TopicApache POI Rewriting

Apache POI Reading Cell Content

Apache POI Reading Cell Content

Apache POI Reading Cell Content Example

Apache Cordova Tutorial

Updating the Document Using XML in Apache Solr

You may also like