java easyexcel 导出多级表头

maven

<dependency>
    <groupId>com.alibabagroupId>
    <artifactId>easyexcelartifactId>
    <version>${easyexcel.version}version>
dependency>

导出行的对象

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;
 
import java.util.Date;
 
@Data
public class ExportItem {
 
    @ExcelProperty({"名称"})
    private String name;
 
 
    @ExcelProperty({"一级","二级头"})
    String data1;
 
    @ExcelProperty({"一级","二级头", "三级头","四级"})
    String data2;
 
    @ExcelProperty({"一级","二级头", "三级头","四级"})
    String data3;
 
 
    /**
     * 忽略这个字段
     */
    @ExcelIgnore
    private String ignoreData;
}
 

导出excel下载

// 导出excel
HttpServletResponse response;
response.setContentType("application/vnd.ms-excel");
response.setCharacterEncoding("utf-8");
 
String fileName = "test_export";
fileName = URLEncoder.encode(fileName,"utf-8").replaceAll("\\+", "%20");
response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
 
 
OutputStream outputStream = response.getOutputStream();
EasyExcel.write(outputStream,ExportItem.class).autoCloseStream(Boolean.FALSE).sheet(fileName).doWrite(exportItems);

https://blog.csdn.net/weixin_51216079/article/details/119782920