package com.zbkj.common.utils; import com.alibaba.excel.converters.Converter; import com.alibaba.excel.converters.WriteConverterContext; import com.alibaba.excel.metadata.data.WriteCellData; import java.text.SimpleDateFormat; import java.util.Date; public class DateConverter implements Converter { private static final String PATTERN = "yyyy-MM-dd HH:mm:ss"; @Override public Class supportJavaTypeKey() { return Date.class; } @Override public WriteCellData convertToExcelData(WriteConverterContext context) throws Exception { Date date = context.getValue(); if (date == null) { return null; } SimpleDateFormat sdf = new SimpleDateFormat(PATTERN); return new WriteCellData<>(sdf.format(date)); } }