easypoi一对多导出excel

最新推荐文章于 2024-05-08 18:01:50 发布

jattxgt

最新推荐文章于 2024-05-08 18:01:50 发布

阅读量1.2k

点赞数 2

分类专栏： java基础文章标签： easypoi java

本文链接：https://blog.csdn.net/qq_38555490/article/details/122358108

版权

java基础专栏收录该内容

12 篇文章 1 订阅

订阅专栏

Employee.java

get,set,constructor省略

package com.easypoi.demo;

import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.excel.annotation.ExcelCollection;

import java.util.Date;
import java.util.List;


public class Employee {

    /**
     * id
     */
    private String id;

    /**
     * 员工姓名
     */
    @Excel(name = "员工姓名",  width = 30,needMerge = true)
    private String name;

    /**
     * 员工性别
     */
    @Excel(name = "员工性别", replace = { "男_1", "女_2" }, suffix = "生", isImportField = "true_st",needMerge = true)
    private int sex;

    @Excel(name = "开始日期", databaseFormat = "yyyyMMddHHmmss", format = "yyyy-MM-dd", isImportField = "true_st", width = 20,needMerge = true)
    private Date birthday;

    @Excel(name = "完工日期", databaseFormat = "yyyyMMddHHmmss", format = "yyyy-MM-dd",needMerge = true)
    private Date registrationDate;

    @ExcelCollection(name = "报销金额")
    private List<BaoXiao> baoxiao;

}

BaoXiao.java

get,set,constructor省略

package com.easypoi.demo;

import cn.afterturn.easypoi.excel.annotation.Excel;

public class BaoXiao {
    /**
     * 火车票金额
     */
    @Excel(name = "火车票金额", width = 30)
    private String hcpje;

    /**
     * 汽车票金额
     */
    @Excel(name = "火车票金额", width = 30)
    private String qcpje;

    public BaoXiao(String hcpje, String qcpje) {
        this.hcpje = hcpje;
        this.qcpje = qcpje;
    }
}

Demo.java

package com.easypoi.demo;

import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import org.apache.poi.ss.usermodel.Workbook;
import org.junit.Test;

import java.io.FileOutputStream;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class Demo {
    @Test
    public void fun(){
        try {
            List<BaoXiao> xiaos = new ArrayList<>();
            BaoXiao baoXiao1 = new BaoXiao("100","200");
            BaoXiao baoXiao2 = new BaoXiao("110","210");
            BaoXiao baoXiao3 = new BaoXiao("120","220");
            BaoXiao baoXiao4 = new BaoXiao("130","230");
            xiaos.add(baoXiao1);
            xiaos.add(baoXiao2);
            xiaos.add(baoXiao3);
            xiaos.add(baoXiao4);

            List<Employee> list = new ArrayList<>();
            Employee s1 = new Employee("001","张三",1,new Date(),new Date(),xiaos);
            Employee s2 = new Employee("002","李四",2,new Date(),new Date(),xiaos);
            Employee s3 = new Employee("003","王五",1,new Date(),new Date(),xiaos);
            Employee s4 = new Employee("004","赵六",2,new Date(),new Date(),xiaos);
            list.add(s1);
            list.add(s2);
            list.add(s3);
            list.add(s4);
            Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("员工差旅报销金额","学生"),
                    Employee.class, list);
            FileOutputStream outputStream = new FileOutputStream("D:/差旅报销金额.xls");
            workbook.write(outputStream);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

效果图