EasyPoi 导出Excel(ExcelExportEntity生成表头)

1 Maven依赖

        <!-- EasyPoi文档处理工具 -->
        <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 调试结果