1.设置单元格为时间格式
File file = new File("路径");
ExcelWriterBuilder builder = EasyExcel.write(file);
builder.excelType(ExcelTypeEnum.XLSX);
builder.registerWriteHandler(new LongestMatchColumnWidthStyleStrategy() {
@Override
public void afterCellDispose(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, @SuppressWarnings("rawtypes") List<CellData> cellDataList, Cell cell, Head head, Integer relativeRowIndex, Boolean isHead) {
if (!isHead && cell.getCellType() == CellType.STRING) {
String value = cell.getStringCellValue();
// 判断为时间(根据自己实际来)
if (value.split("-").length == 3) {
Date date = 转换为时间;
if (null != date) {
Workbook workbook = writeSheetHolder.getSheet().getWorkbook();
CreationHelper factory = workbook.getCreationHelper();
CellStyle style = workbook.createCellStyle();
style.setDataFormat(factory.createDataFormat().getFormat("yyyy/m/d"));
cell.setCellValue(date);
cell.setCellStyle(style);
}
}
}
super.afterCellDispose(writeSheetHolder, writeTableHolder, cellDataList, cell, head, relativeRowIndex, isHead);
}
});
builder.head(头);
ExcelWriterSheetBuilder sheetBuilder = builder.sheet(名称);
sheetBuilder.doWrite(内容);