cq-yxfwzx-project-manager-ds/src/main/java/com/migao/util/LocalDateTimeConverter.java

package com.migao.util;

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 LocalDateTimeConverter extends BaseWriteConverter<LocalDateTime> {

    @Override
    public CellData convertToExcelData(LocalDateTime value, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) throws Exception {
        String date = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss").format(value);
        return new CellData(date);
    }

    @Override
    public LocalDateTime convertToJavaData(CellData cellData, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) throws Exception {
        String date = cellData.getStringValue();
        return LocalDateTime.parse(date, DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));
    }
}