Apache POI Excel Cell Type

by Online Tutorials Library July 14, 2022

Apache POI Excel Cell Type

To set various types of values in cell, Apache POI provides overloading function setCellValue() which allows us to set values as per the requirement.

In the following example, we have created various cells to hold values of different-different types.

Apache POI Excel Cell Type Example

  package poiexample;  import java.io.FileOutputStream;  import java.io.OutputStream;  import java.util.Calendar;  import java.util.Date;  import org.apache.poi.hssf.usermodel.HSSFWorkbook;  import org.apache.poi.ss.usermodel.CellType;  import org.apache.poi.ss.usermodel.Row;  import org.apache.poi.ss.usermodel.Sheet;  import org.apache.poi.ss.usermodel.Workbook;  public class CellTypeExample {  public static void main(String[] args) {  try (OutputStream os = new FileOutputStream(“tutoraspire.xls”)) {  Workbook wb = new HSSFWorkbook();      Sheet sheet = wb.createSheet(“Sheet”);      Row row = sheet.createRow(2);                                row.createCell(0).setCellValue(1.1); // Float value      row.createCell(1).setCellValue(” “+new Date()); // Date type       row.createCell(2).setCellValue(” “+Calendar.getInstance());// Calendar      row.createCell(3).setCellValue(“a string value”); // String      row.createCell(4).setCellValue(true); // Boolean      row.createCell(5).setCellType(CellType.ERROR); // Error      wb.write(os);      }catch(Exception e) {      System.out.println(e.getMessage());      }  }  }  

Output:

Apache POI Excel Cell Type

Next TopicApache POI Drawing Shape

Apache POI Excel Cell Type

Apache POI Excel Cell Type

Apache POI Excel Cell Type Example

Apache Cordova Tutorial

Updating the Document Using XML in Apache Solr

You may also like