EasyExcel 自定义DateTime类型转换器Converter

1 Maven依赖

        <!--    easyexcel文档处理工具    -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.2.8</version>
        </dependency>
        <!--    hutool工具包    -->
        <dependency>
            <groupId>cn.hutool</groupId>
            <artifactId>hutool-all</artifactId>
            <version>5.6.2</version>
        </dependency>

2 DateTimeConverter

package com.convert;

import cn.hutool.core.date.DateTime;
import cn.hutool.core.date.DateUtil;
import com.alibaba.excel.converters.Converter;
import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.*;
import com.alibaba.excel.metadata.property.ExcelContentProperty;
import org.springframework.stereotype.Component;

/**
 * DateTime类型转换器
 */
@Component
public class DateTimeConverter implements Converter<DateTime> {
    @Override
    public Class<DateTime> supportJavaTypeKey() {
        return DateTime.class;
    }

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

    @Override
    public DateTime convertToJavaData(CellData cellData, ExcelContentProperty excelContentProperty
            , GlobalConfiguration globalConfiguration) throws Exception {
        return DateUtil.parse(cellData.getStringValue(), "yyyy-MM-dd HH:mm:ss");
    }

    @Override
    public CellData convertToExcelData(DateTime dateTime, ExcelContentProperty excelContentProperty
            , GlobalConfiguration globalConfiguration) throws Exception {
        return new CellData<>(DateUtil.format(dateTime, "yyyy-MM-dd HH:mm:ss"));
    }
}

3 调试代码

    /**
     * 调试自定义Convert
     *
     * @param response
     */
    @GetMapping("/customDateTimeConvert")
    public void customDateTimeConvert(HttpServletResponse response) throws IOException {
        List<List<Object>> sheetDataList = new ArrayList<>();
        List<Object> rowList = new ArrayList<>();
        rowList.add(DateUtil.parse("2021-08-23 20:20:20"));
        sheetDataList.add(rowList);
        response.addHeader("Content-Disposition", "filename=test.xlsx");
        //设置类型,扩展名为.xls
        response.setContentType("application/vnd.ms-excel");
        ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream())
                //加载类型转换器
                .registerConverter(new DateTimeConverter()).build();
        WriteSheet writeSheet = EasyExcel.writerSheet("模板").build();
        excelWriter.write(sheetDataList, writeSheet);
        //千万别忘记finish 会帮忙关闭流
        excelWriter.finish();
    }

4 调试结果 

 

  • 1
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值