java easyexcel 导出多级表头

easyexcel

快速、简洁、解决大文件内存溢出的java处理Excel工具

项目地址：https://gitcode.com/gh_mirrors/ea/easyexcel

免费下载资源

wangooo

1991人浏览 · 2023-09-21 15:20:27

wangooo · 2023-09-21 15:20:27 发布

maven

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <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