package com.linghu.model.excel; import com.alibaba.excel.annotation.ExcelIgnore; import com.alibaba.excel.annotation.ExcelProperty; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; import java.time.LocalDate; import java.time.LocalDateTime; @Data public class ReferenceExcel { @ExcelProperty("发布平台") private String platform_name; @ExcelProperty("标题") private String title; @ExcelProperty("发布时间") // 关键:指定日期格式为 yyyy-MM-dd HH:mm:ss @DateTimeFormat(pattern = "yyyy/MM/dd") @JsonFormat(pattern = "yyyy/MM/dd") private LocalDate create_time; @ExcelProperty("发布网址") private String url; @ExcelIgnore private LocalDateTime createTimeAsDateTime; @ExcelIgnore @ApiModelProperty(hidden = true) private String timeString; }