EasyPoi 导出Excel(ExcelExportEntity生成表头)

悠悠 2022-09-02 15:40 345阅读 0赞

### 1 Maven依赖 ###

<dependency>
                <groupId>cn.afterturn</groupId>
                <artifactId>easypoi-base</artifactId>
                <version>4.4.0</version>
            </dependency>

### 2 调试代码 ###

/**
         * 写入数据导出Excel
         *
         * @param response
         */
        @GetMapping("/writeExcel")
        public void writeExcel(HttpServletResponse response) throws IOException {
            ExportParams params = new ExportParams();
            //生成要导出的数据
            List<Map<String, Object>> resultList = new ArrayList<>();
            List<List<Object>> tempDataList = new ArrayList<>();
            List<Object> tempRowList1 = new ArrayList<>(Arrays.asList(0, 1, 2, 3, 4, 5, 6, 7, 8, 9));
            tempDataList.add(tempRowList1);
            List<Object> tempRowList2 = new ArrayList<>(Arrays.asList(0, 1, 8, 3, 4, 5, 7, 7, 8, 9));
            tempDataList.add(tempRowList2);
            List<Object> tempRowList3 = new ArrayList<>(Arrays.asList(1, 1, 2, 8, 4, 5, 6, 7, 8, 8));
            tempDataList.add(tempRowList3);
            for (List<Object> rowList : tempDataList) {
                Map<String, Object> rowMap = new HashMap<>();
                for (int i = 1; i <= rowList.size(); i++) {
                    rowMap.put("title" + i, rowList.get(i - 1));
                }
                resultList.add(rowMap);
            }
            //列名
            List<ExcelExportEntity> entityList = new ArrayList<>();
            for (int i = 1; i <= tempRowList1.size(); i++) {
                ExcelExportEntity entity = new ExcelExportEntity("标题" + i, "title" + i);
                entityList.add(entity);
            }
            Workbook workbook = ExcelExportUtil.exportExcel(params, entityList, resultList);
    
            response.addHeader("Content-Disposition", "filename=test.xlsx");
            //设置类型，扩展名为.xls
            response.setContentType("application/vnd.ms-excel");
            workbook.write(response.getOutputStream());
        }

### 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]: /images/20220829/de1a0cb25fe844d2ad7b546eccbd0bc0.png