Apache POI Excel Date Cell

by Online Tutorials Library July 14, 2022

Apache POI Excel Date Cell

To create date cell which display current date to the cell, we can use Apache POI’s style feature to format the cell according to the date. The setDateformat() method is used to set date format.

Lets see an example in which we are creating a cell containing current date.

Apache POI Excel Date Cell Example

  package poiexample;  import java.io.FileNotFoundException;  import java.io.FileOutputStream;  import java.io.IOException;  import java.io.OutputStream;  import java.util.Date;  import org.apache.poi.hssf.usermodel.HSSFWorkbook;  import org.apache.poi.ss.usermodel.Cell;  import org.apache.poi.ss.usermodel.CellStyle;  import org.apache.poi.ss.usermodel.CreationHelper;  import org.apache.poi.ss.usermodel.Row;  import org.apache.poi.ss.usermodel.Sheet;  import org.apache.poi.ss.usermodel.Workbook;  public class DateCellExample {    public static void main(String[] args) throws FileNotFoundException, IOException {  Workbook wb = new HSSFWorkbook();  CreationHelper createHelper = wb.getCreationHelper();      try(OutputStream os = new FileOutputStream(“tutoraspire.xls”)){          Sheet sheet = wb.createSheet(“New Sheet”);          Row row     = sheet.createRow(0);          Cell cell   = row.createCell(0);          CellStyle cellStyle = wb.createCellStyle();          cellStyle.setDataFormat(              createHelper.createDataFormat().getFormat(“d/m/yy h:mm”));          cell = row.createCell(1);          cell.setCellValue(new Date());          cell.setCellStyle(cellStyle);          wb.write(os);      }catch(Exception e) {      System.out.println(e.getMessage());      }  }  }  

Output:

Next TopicApache POI Excel Align Cell

Apache POI Excel Date Cell

Apache POI Excel Date Cell

Apache POI Excel Date Cell Example

Apache Cordova Tutorial

Updating the Document Using XML in Apache Solr

You may also like