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("Javatpoint.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: