EasyExcel 2.x导出字段支持LocalDateTime和LocalDate

最新推荐文章于 2024-09-29 16:52:07 发布

我不知道也不关心

最新推荐文章于 2024-09-29 16:52:07 发布

阅读量860

点赞数

分类专栏： Java 文章标签： java spring spring boot

本文链接：https://blog.csdn.net/bruce1114/article/details/126540101

版权

Java 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

本文介绍了一种使用Hutool日期处理工具实现的自定义日期转换器，适用于将Excel单元格中的日期字符串转换为Java中的LocalDate和LocalDateTime对象。通过实现Converter接口，该转换器能够灵活地处理不同格式的日期数据。

摘要由CSDN通过智能技术生成

需要自定义日期转换器，代码如下。

里面用来Hutool的日期处理工具，你也可以自己写日期转换工具类来处理。

@Data
@ExcelIgnoreUnannotated
public class OfficialAccountImportDTO {

    @ExcelProperty("真实姓名")
    private String name;

    @ExcelProperty("手机号")
    private String phone;

    @ExcelProperty(value = "生日",converter = EasyExcelLocalDateConverter.class)
    @JsonFormat(pattern = "yyyy/MM/dd")
    private LocalDate birthday;

    @ExcelProperty("公司")
    private String company;

    @ExcelProperty(value = "注册时间",converter = EasyExcelLocalDateTimeConverter.class)
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime createTime;

    @ExcelProperty("审核状态")
    private String auditStatus;

    @ExcelProperty("审核不通过原因")
    private String failReasons;

    @ExcelProperty(value = "审核时间",converter = EasyExcelLocalDateTimeConverter.class)
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime updateTime;

}

import cn.hutool.core.date.DatePattern;
import com.alibaba.excel.converters.Converter;
import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.CellData;
import com.alibaba.excel.metadata.GlobalConfiguration;
import com.alibaba.excel.metadata.property.ExcelContentProperty;

import java.time.LocalDate;
import java.time.format.DateTimeFormatter;

public class EasyExcelLocalDateConverter implements Converter<LocalDate> {

    @Override
    public Class supportJavaTypeKey() {
        return LocalDate.class;
    }

    @Override
    public CellDataTypeEnum supportExcelTypeKey() {
        return CellDataTypeEnum.STRING;
    }

    @Override
    public LocalDate convertToJavaData(CellData cellData, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) {
        return LocalDate.parse(cellData.getStringValue(), DateTimeFormatter.ofPattern(DatePattern.NORM_DATE_PATTERN));
    }

    @Override
    public CellData convertToExcelData(LocalDate value, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) {
        return new CellData<>(value.format(DateTimeFormatter.ofPattern(DatePattern.NORM_DATE_PATTERN)));
    }

}

import cn.hutool.core.date.DatePattern;
import com.alibaba.excel.converters.Converter;
import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.CellData;
import com.alibaba.excel.metadata.GlobalConfiguration;
import com.alibaba.excel.metadata.property.ExcelContentProperty;

import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;


public class EasyExcelLocalDateTimeConverter implements Converter<LocalDateTime> {

    @Override
    public Class supportJavaTypeKey() {
        return LocalDateTime.class;
    }

    @Override
    public CellDataTypeEnum supportExcelTypeKey() {
        return CellDataTypeEnum.STRING;
    }

    @Override
    public LocalDateTime convertToJavaData(CellData cellData, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) {
        return LocalDateTime.parse(cellData.getStringValue(), DateTimeFormatter.ofPattern(DatePattern.NORM_DATETIME_PATTERN));
    }

    @Override
    public CellData convertToExcelData(LocalDateTime value, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) {
        return new CellData<>(value.format(DateTimeFormatter.ofPattern(DatePattern.NORM_DATETIME_PATTERN)));
    }

}