java easyexcel 导出多级表头

使用MavenEasyExcel实现Excel数据导出

原创已于 2023-09-24 20:55:15 修改 · 1.9k 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#java #python #前端

于 2023-09-21 15:20:27 首次发布

本文介绍了如何在Java项目中使用Maven引入EasyExcel库，定义导出Excel的数据模型，并演示了如何生成并下载包含自定义字段注解的Excel文件。

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.youkuaiyun.com/weixin_51216079/article/details/119782920