easyexcel导出时间类型

为了在EasyExcel中导出时间类型，需要使用Converter类将LocalDate转换为Date类型。如果没有正确配置Converter类，则会出现“Cannot find ‘Converter’ support class LocalDate”异常。

以下是一个示例代码，演示如何在EasyExcel中导出时间类型：

// 定义Converter类，将LocalDate转换为Date类型
public class LocalDateConverter implements Converter<LocalDate> {
    @Override
    public Class supportJavaTypeKey() {
        return LocalDate.class;
    }

    @Override
    public CellData convertToExcelData(LocalDate value, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) {
        return new CellData(Date.from(value.atStartOfDay(ZoneId.systemDefault()).toInstant()));
    }

    @Override
    public LocalDate convertToJavaData(CellData cellData, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) {
        return cellData.getDateValue().toInstant().atZone(ZoneId.systemDefault()).toLocalDate();
    }
}

// 在导出Excel时，使用Converter类将LocalDate转换为Date类型
public void exportExcel() {
    List<Data> dataList = getDataList();
    String fileName = "data.xlsx";
    try (OutputStream out = new FileOutputStream(fileName)) {
        ExcelWriter writer = EasyExcel.write(out).build();
        Sheet sheet = new Sheet(1, 0, Data.class);
        sheet.setSheetName("Sheet1");
        writer.registerConverter(new LocalDateConverter()); // 注册Converter类
        writer.write(dataList, sheet);
        writer.finish();
    } catch (IOException e) {
        e.printStackTrace();
    }
}