在Spring Boot中使用EasyExcel导入和导出Excel时,可以自定义时间格式。以下是一个简单的例子,展示了如何在导入和导出时设置时间格式。
首先,添加EasyExcel的依赖到你的pom.xml文件中:
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <version>2.2.6</version>
</dependency>导出时自定义时间格式:
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.write.metadata.WriteSheet;
import java.util.Date;
import java.util.List;
 
public class ExcelExportExample {
 
    public static void exportExcel(List<DataModel> data, String fileName) {
        WriteSheet writeSheet = EasyExcel.writerSheet("Sheet1").build();
        // 自定义时间格式
        String timeFormat = "yyyy-MM-dd HH:mm:ss";
        EasyExcel.write(fileName, DataModel.class)
                .registerWriteHandler(new SimpleDateFormatHandler(timeFormat))
                .sheet("Sheet1")
                .doWrite(data);
    }
 
    public static class DataModel {
        @DateTimeFormat("yyyy-MM-dd HH:mm:ss")
        private Date dateTime;
 
        // getters and setters
    }
}导入时自定义时间格式:
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.read.listener.ReadListener;
import com.alibaba.excel.read.metadata.ReadSheet;
 
public class ExcelImportExample {
 
    public static void importExcel(String fileName, ReadListener<DataModel> listener) {
        ReadSheet readSheet = EasyExcel.readSheet("Sheet1").build();
        // 自定义时间格式
        String timeFormat = "yyyy-MM-dd HH:mm:ss";
        EasyExcel.read(fileName, DataModel.class, listener)
                .registerReadHandler(new SimpleDateFormatHandler(timeFormat))
                .sheet(readSheet)
                .doRead();
    }
 
    public static class DataModel {
        @DateTimeFormat("yyyy-MM-dd HH:mm:ss")
        private Date dateTime;
 
        // getters and setters
    }
}SimpleDateFormatHandler是一个自定义的处理器,需要你实现它来处理时间格式化:
import com.alibaba.excel.converters.Converter;
import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.GlobalConfiguration;
import com.alibaba.excel.metadata.data.ReadCellData;
import com.alibaba.excel.metadata.data.WriteCellData;
import com.alibaba.excel.metadata.property.ExcelContentProperty;
 
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
 
public class SimpleDateFormatHandler implements Converter<Date> {
    private SimpleDateFormat simpleDateFor            