package com.ruoyi.common.utils.converter; 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 DateMonthConverter implements Converter { private static final String PATTERN_YYYY_MM = "yyyy-MM"; @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_YYYY_MM); return new WriteCellData<>(sdf.format(date)); } }