当前位置：首页 > news >正文

Java学习之 EasyExcel

news 2026/4/17 8:59:47

package com.dream.data.form;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.*;
import com.alibaba.excel.enums.BooleanEnum;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.springframework.format.annotation.DateTimeFormat;
import java.time.LocalDate;

@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@HeadStyle(horizontalAlignment = HorizontalAlignmentEnum.CENTER)
@HeadFontStyle(fontName = "微软雅黑", fontHeightInPoints = 11, bold = BooleanEnum.TRUE)
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.CENTER)
@ContentFontStyle(fontName = "微软雅黑", fontHeightInPoints = 11)
public class MatchForm {

    /**时间*/
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    @ExcelProperty(value="比赛时间", index = 0)
    @ColumnWidth(16)
    private LocalDate matchDate;

    /**联赛*/
    @ExcelProperty(value = "联赛", index = 1)
    @ColumnWidth(12)
    private String leagueName;

    /**主队*/
    @ExcelProperty(value = "主队", index = 2)
    @ColumnWidth(20)
    private String homeTeam;

    /**客队*/
    @ExcelProperty(value = "客队", index = 3)
    @ColumnWidth(20)
    private String awayTeam;

    @ExcelProperty(value = "高于", index = 4)
    @ColumnWidth(12)
    private String concedeGreater;

    @ExcelProperty(value = "让球", index = 5)
    @ColumnWidth(12)
    private String concede;

    @ExcelProperty(value = "低于", index = 6)
    @ColumnWidth(12)
    private String concedeLess;

    @ExcelProperty(value = "高于", index = 7)
    @ColumnWidth(12)
    private String goalsGreater;

    @ExcelProperty(value = "大小球", index = 8)
    @ColumnWidth(12)
    private String goals;

    @ExcelProperty(value = "低于", index = 9)
    @ColumnWidth(12)
    private String goalsLess;

    @ExcelProperty(value = "比分(全)", index = 10)
    @ColumnWidth(12)
    private String fullScore;

    @ExcelProperty(value = "比分(半)", index = 11)
    @ColumnWidth(12)
    private String halfScore;
}