代码示例:
DataFormatter formatter = new DataFormatter(); LocalDateTime dateTime = LocalDateTime.now(); Cell cell = row.createCell(cellNum); cell.setCellValue(dateTime); String formattedDateTime = formatter.formatCellValue(cell); System.out.println(formattedDateTime);
代码示例:
CellStyle dateCellStyle = workbook.createCellStyle(); dateCellStyle.setDataFormat(workbook.getCreationHelper().createDataFormat().getFormat("yyyy-MM-dd HH:mm:ss")); LocalDateTime dateTime = LocalDateTime.now(); Cell cell = row.createCell(cellNum); cell.setCellValue(dateTime); cell.setCellStyle(dateCellStyle); System.out.println(cell.toString());