java easyexcel 导出多级表头

wangooo

已于 2023-09-24 20:55:15 修改

阅读量1.6k

点赞数

文章标签： java python 前端

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

本文链接：https://blog.csdn.net/wangooo/article/details/133134821

版权

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