EasyExcel 实现多个Sheet页导出

超、凢脫俗 2023-01-16 06:18 154阅读 0赞

### 1 Maven依赖 ###

<dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>easyexcel</artifactId>
                <version>2.1.6</version>
            </dependency>

### 2 实现代码 ###

/**
         * 导出多个sheet页数据
         *
         * @param response
         */
        @GetMapping("/exportMultiSheet")
        public void exportMultiSheet(HttpServletResponse response) {
            try {
                //第一个Sheet页数据
                List<List<Object>> dataList = new ArrayList<>();
                List<Object> headList = new ArrayList<>(Arrays.asList(new Object[]{"表头1", "表头2", "表头3"}));
                dataList.add(headList);
    
                //第二个Sheet页数据
                List<List<Object>> dataList2 = new ArrayList<>();
                List<Object> headList2 = new ArrayList<>(Arrays.asList(new Object[]{"表头1", "表头2", "表头3", "表头4"}));
                dataList2.add(headList2);
                String fileName = new String("文件名称.xls".getBytes(), "UTF-8");
                response.addHeader("Content-Disposition", "filename=" + fileName);
                //设置类型，扩展名为.xls
                response.setContentType("application/vnd.ms-excel");
    
                //将数据写入sheet页中
                ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).build();
                WriteSheet writeSheet1 = EasyExcel.writerSheet(0, "sheet1").build();
                WriteSheet writeSheet2 = EasyExcel.writerSheet(1, "sheet2").build();
                excelWriter.write(dataList, writeSheet1);
                excelWriter.write(dataList2, writeSheet2);
                excelWriter.finish();
                response.flushBuffer();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

### 3 调试结果 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70 2][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70]: /images/20221022/7ee2e4bd64084629ba80f41aca76ce74.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20210424101626108.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70 2]: /images/20221022/ea71923fe18c4b2f803725bde0ab3b17.png