EasyExcel 生成动态表头

最新推荐文章于 2024-04-09 11:07:43 发布

Qfbly_01

最新推荐文章于 2024-04-09 11:07:43 发布

阅读量1.7k

点赞数

文章标签： java

原文链接：https://www.yuque.com/easyexcel/doc/write#b4b9de00

版权

EasyExcel

参考链接: https://www.yuque.com/easyexcel/doc/write#b4b9de00

EasyExcel固定表头导出：

       response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        response.setCharacterEncoding("utf-8");
        String fileName = URLEncoder.encode(excelName, "UTF-8").replaceAll("\\+", "%20");
        response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
        EasyExcel.write(response.getOutputStream(), cla).excelType(ExcelTypeEnum.XLSX).sheet(excelName).doWrite(list);

EasyExcel动态表头导出:

EasyExcel.write(response.getOutputStream()).head(head).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()).sheet(excelName).doWrite(list);
// 动态头
public List<List<String>> head() {
        List<List<String>> head = new ArrayList<>();
        List<String> head0 = new ArrayList<>();
        head0.add("性别");
        List<String> head1 = new ArrayList<>();
        head1.add("姓名");
        List<String> head2 = new ArrayList<>();
        head2.add("手机号");
        List<String> head3 = new ArrayList<>();
        head3.add("家庭住址");
        head.add(head0);
        head.add(head1);
        head.add(head2);
        head.add(head3);
        return head;
    }
//数据
List<List<Object>> list = Lists.newArrayList();