Java Excel复杂表头，表头合并单元格

Java Excel复杂表头，表头合并单元格

效果预览

一、maven依赖

 <!--操作excel -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.1.1</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.1.1</version>
            <scope>compile</scope>
        </dependency>

二、Excel DTO

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;

import java.util.Date;

//导出数据成excel  多级头导出  配合测试类
@Data
public class DemoData {

    @ExcelProperty({"序号"})
    private Integer orderNumber;
    
    @ExcelProperty({"一级","二三四级"})
    private String ceshi;
    
    @ExcelProperty({"一级","二级头", "三级头","四级"})
    private String string;

    @ExcelProperty({"一级","二级头", "三级头","四级"})
    private Date date;

    @ExcelProperty({"一级","二级头", "三级头","四级"})
    private Double doubleData;

    @ExcelIgnore
    private String ignore;
}

三、测试类

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

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.write.merge.LoopMergeStrategy;

public class Test {

	public static void main(String[] args) {
		Test.mergeWrite();
		System.out.println("hao");
	}
	
	//多级输出excel
    public static void mergeWrite() {
        //创建数据
        List<DemoData> list = new ArrayList<DemoData>();

        for (int i = 0; i < 10; i++) {

            DemoData data = new DemoData();
            data.setOrderNumber(i);
            data.setCeshi("测试");

            data.setString("测试" + i);

            data.setDate(new Date());

            data.setDoubleData(0.820);

            list.add(data);

        }
        //文件名
        String fileName = System.currentTimeMillis()+".xlsx";
        
        // 每隔2行会合并 把eachColumn 设置成 3 也就是我们数据的长度，所以就第一列会合并。当然其他合并策略也可以自己写
        LoopMergeStrategy loopMergeStrategy = new LoopMergeStrategy(2, 1);
        
        // 这里 需要指定写用哪个class去写，然后写到第一个sheet，名字为模板 然后文件流会自动关闭
        EasyExcel.write(fileName, DemoData.class).registerWriteHandler(loopMergeStrategy).sheet("合并单元格")
                .doWrite(list);
    }
}