summer-excel数据写入_excel中summer-优快云博客

本文链接：https://blog.youkuaiyun.com/dhweicheng/article/details/100070059

summer-excel是一款基于POI的对象关系映射工具，支持Excel数据的读取和写入。通过注解实现数据关系映射，提供定制解析策略，适用于多种业务场景。本文介绍其使用方法及实体定义注意事项。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

summer-excel是一款基于对象关系映射稳定、便捷、可定制的Excel数据读取工具，基于POI打造支持。利用注解实现Excel数据关系映射，可定制解析策略，以满足不同业务场景的需要。

Excel数据读取：https://blog.youkuaiyun.com/dhweicheng/article/details/90005975

从0.4.0版本开始，支持Excel数据写入功能

<dependency>
  <groupId>tk.jfree.summer</groupId>
  <artifactId>summer-excel</artifactId>
  <version>0.4.0</version>
</dependency>

实体定义

注意事项（对于部分数据：时间、货币等可通过format字段定义格式，格式样式可直接在excel的单元格样式内取得）
Alt

@Getter
@Setter
@ToString
@Table(sheet = "日志信息", first = 1)
public class Log implements Serializable {
    @Column(name = "A", notes = "账号", typeHandler = StringTypeHandler.class)
    private String username;
    @Column(name = "B", notes = "时间")
    private java.util.Date gmtCreate;
    @Column(name = "C", notes = "操作", typeHandler = StringTypeHandler.class)
    private String type;
    @Column(name = "D", notes = "年龄", typeHandler = IntegerTypeHandler.class)
    private Integer age;
    @Column(name = "E", notes = "价格1", format = "¥#,##0_);(¥#,##0)", typeHandler = DoubleTypeHandler.class)
    private Double price1;
    @Column(name = "F", notes = "价格2", format = "¥#,##0.00_);(¥#,##0.00)",typeHandler = DoubleTypeHandler.class)
    private Double price2;
    @Column(name = "G", notes = "日期", typeHandler = DateTypeHandler.class)
    private java.sql.Date sqlDate;
}

调用写入方法

public class ExportTest {
    public static void main(String[] args) throws Exception {
        List<Log> logs = new ArrayList<>();
        Log log1 = new Log();
        log1.setUsername("admin");
        log1.setType("新增");
        log1.setGmtCreate(new Date());
        log1.setAge(20);
        log1.setPrice1(20.118D);
        log1.setPrice2(13.1415);
        log1.setSqlDate(new java.sql.Date(System.currentTimeMillis()));
        logs.add(log1);
        Log log2 = new Log();
        log2.setUsername("super");
        log2.setType("修改");
        log2.setGmtCreate(new Date());
        log2.setAge(22);
        log2.setPrice1(22110.228D);
        log2.setPrice2(10.1415);
        log2.setSqlDate(new java.sql.Date(System.currentTimeMillis()+24*60*60*1000));
        logs.add(log2);
        Workbook workbook = ExcelHelper.builder(Log.class).write(logs);
        try( FileOutputStream o = new FileOutputStream("d:\\1234.xlsx")){
            workbook.write(o);
        }catch (Exception e){
            e.printStackTrace();
        }
}