NPOI Generate Excel with Date Format

Jika kita ingin memasukkan object DateTime ke dalam cell menggunakan NPOI, perlu ada penanganan khusus.

[code language=”csharp”]
XSSFCellStyle styleDate = (XSSFCellStyle)workbook.CreateCellStyle();
styleDate.DataFormat = workbook.CreateDataFormat().GetFormat("yyyy-mm-dd HH:mm");

XSSFCell cell = (XSSFCell)row.CreateCell(colIndex++);
cell.SetCellValue(single.Timestamp);
cell.CellStyle = styleDate;
[/code]

http://stackoverflow.com/questions/3425931/npoi-excel-number-format-not-showing-in-excel-sheet-in-asp-net