EasyPOI导出

最新推荐文章于 2024-09-21 14:49:00 发布
最新推荐文章于 2024-09-21 14:49:00 发布
阅读量510 收藏
点赞数
分类专栏： java 文章标签： intellij idea java linux
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/ShineupUP/article/details/121492167
版权

模板方式导出

  1. 添加批注
	jx:area(lastCell="P3")
	jx:each(items="workTicketHighRiskList" var="work" lastCell="P3")
  1. 添加占位符
    ${work.enterpriseName}

类似这样
在这里插入图片描述

相关代码

//获取模板地址
        String templatesPath = "/templates/HighRiskSheetExportTemplate.xlsx";
        
InputStream inputStream = null;
        OutputStream outputStream;
        try {
            inputStream = this.getClass().getResourceAsStream(templatesPath);
            name = URLEncoder.encode(name, "UTF-8");
            response.setContentType("application/octet-stream;charset=utf-8");
            response.setHeader("Content-Disposition", "attachment; filename*=utf-8'zh_cn'" + name);
            response.resetBuffer();
            outputStream = response.getOutputStream();

			//获取导出数据集合
			List<AppWorkTicketHighRiskCountHyResult> resultList=new ArrayList();

			List<Map<String, Object>> workTicketHighRiskList = new ArrayList<>();
            for (AppWorkTicketHighRiskCountHyResult result : resultList) {
                Map<String, Object> workTicketHighRiskMap = new HashMap<>();
                workTicketHighRiskMap.put("enterpriseName", result.getEnterpriseName());
                workTicketHighRiskMap.put("workTicketValid", result.getWorkTicketValid());
                workTicketHighRiskMap.put("workTicketInvalid", result.getWorkTicketInvalid());
                workTicketHighRiskMap.put("workTicketCount", result.getWorkTicketCount());

                workTicketHighRiskList.add(workTicketHighRiskMap);
            }
            resultData.put("workTicketHighRiskList", workTicketHighRiskList);
            ExcelExportUtils.exportExcel(inputStream, outputStream, resultData);

        } catch (Exception e) {
            e.printStackTrace();
            logger.error("导出错误：" + e);
        }

注解方式导出

结果集实体上添加注解
@Excel(name = “xx”)

根据条件查询到要导出的结果集

//对应的要导出的数据列表
ArrayList<AppMajorHazardExcelExportVO> list = new ArrayList<>();

ExcelExportManage.exportExcel(list, null, "数据导出", AppMajorHazardExcelExportVO.class, "指定的导出的文件名称.xls", res);

ExcelExportManage 工具类

public class ExcelExportManage {
    private static final Logger log = LoggerFactory.getLogger(ExcelExportManage.class);

    public ExcelExportManage() {
    }

    public static void exportExcel(List<?> list, String title, String sheetName, Class<?> pojoClass, String fileName, boolean isCreateHeader, HttpServletResponse response) {
        ExportParams exportParams = new ExportParams(title, sheetName);
        exportParams.setCreateHeadRows(isCreateHeader);
        defaultExport(list, pojoClass, fileName, response, exportParams);
    }

    public static void exportExcel(List<?> list, String title, String sheetName, Class<?> pojoClass, String fileName, HttpServletResponse response) {
        defaultExport(list, pojoClass, fileName, response, new ExportParams(title, sheetName));
    }

    public static void exportExcel(List<Map<String, Object>> list, String fileName, HttpServletResponse response) {
        defaultExport(list, fileName, response);
    }

    public static void exportBigExcel(Class<?> pojoClass, String fileName, IExcelExportServer iExcelExportServer, Object queryParams, HttpServletResponse response) {
        ExportParams exportParams = new ExportParams();
        defaultBigExport(exportParams, pojoClass, fileName, iExcelExportServer, queryParams, response);
    }

    public static void exportBigExcel(ExportParams exportParams, Class<?> pojoClass, String fileName, IExcelExportServer iExcelExportServer, Object queryParams, HttpServletResponse response) {
        defaultBigExport(exportParams, pojoClass, fileName, iExcelExportServer, queryParams, response);
    }

    public static void exportBigExcel(String title, String sheetName, Class<?> pojoClass, String fileName, IExcelExportServer iExcelExportServer, Object queryParams, HttpServletResponse response) {
        ExportParams exportParams = new ExportParams(title, sheetName);
        defaultBigExport(exportParams, pojoClass, fileName, iExcelExportServer, queryParams, response);
    }

    private static void defaultExport(List<?> list, Class<?> pojoClass, String fileName, HttpServletResponse response, ExportParams exportParams) {
        Workbook workbook = ExcelExportUtil.exportExcel(exportParams, pojoClass, list);
        if (workbook != null) {
        }

        downLoadExcel(fileName, response, workbook);
    }

    private static void defaultBigExport(ExportParams exportParams, Class<?> pojoClass, String fileName, IExcelExportServer iExcelExportServer, Object queryParams, HttpServletResponse response) {
        Workbook workbook = ExcelExportUtil.exportBigExcel(exportParams, pojoClass, iExcelExportServer, queryParams);
        if (workbook != null) {
        }

        downLoadExcel(fileName, response, workbook);
    }

    private static void downLoadExcel(String fileName, HttpServletResponse response, Workbook workbook) {
        try {
            response.setCharacterEncoding("UTF-8");
            response.setHeader("content-Type", "application/vnd.ms-excel");
            response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
            workbook.write(response.getOutputStream());
        } catch (IOException var4) {
            log.error("导出失败！{}", var4.getMessage());
        }

    }

    private static void defaultExport(List<Map<String, Object>> list, String fileName, HttpServletResponse response) {
        Workbook workbook = ExcelExportUtil.exportExcel(list, ExcelType.HSSF);
        if (workbook != null) {
        }

        downLoadExcel(fileName, response, workbook);
    }

    public static SXSSFWorkbook getSXSSFWorkbookAssets(String sheetName, String[] titles, int[] columnLength, int[] columnHidden, String[] names, CellRangeAddressList rangeAddressList, CellRangeAddressList rangeAddressListNumber) {
        SXSSFWorkbook workbook = new SXSSFWorkbook();
        CellStyle cellStyleTitle = workbook.createCellStyle();
        cellStyleTitle.setBorderBottom(BorderStyle.THIN);
        cellStyleTitle.setBorderLeft(BorderStyle.THIN);
        cellStyleTitle.setBorderTop(BorderStyle.THIN);
        cellStyleTitle.setBorderRight(BorderStyle.THIN);
        cellStyleTitle.setAlignment(HorizontalAlignment.CENTER);
        cellStyleTitle.setVerticalAlignment(VerticalAlignment.CENTER);
        Font fontTitle = workbook.createFont();
        fontTitle.setFontName("宋体");
        fontTitle.setFontHeightInPoints((short)12);
        fontTitle.setBold(true);
        cellStyleTitle.setFont(fontTitle);
        cellStyleTitle.setWrapText(true);
        Sheet sheet = workbook.createSheet(sheetName);
        DataValidationHelper helper;
        DataValidationConstraint numericConstraint;
        if (names != null && rangeAddressList != null) {
            helper = sheet.getDataValidationHelper();
            numericConstraint = helper.createExplicitListConstraint(names);
            DataValidation dataValidation = helper.createValidation(numericConstraint, rangeAddressList);
            if (dataValidation instanceof XSSFDataValidation) {
                dataValidation.setSuppressDropDownArrow(true);
                dataValidation.setShowErrorBox(true);
            } else {
                dataValidation.setSuppressDropDownArrow(false);
            }

            sheet.addValidationData(dataValidation);
        }

        if (rangeAddressListNumber != null) {
            helper = sheet.getDataValidationHelper();
            numericConstraint = helper.createNumericConstraint(2, 0, "0", "2000000");
            CellRangeAddressList regions = new CellRangeAddressList(1, 2000, 22, 25);
            DataValidation dataValidation = helper.createValidation(numericConstraint, regions);
            if (dataValidation instanceof XSSFDataValidation) {
                dataValidation.setSuppressDropDownArrow(true);
                dataValidation.setShowErrorBox(true);
            } else {
                dataValidation.setSuppressDropDownArrow(false);
            }

            sheet.addValidationData(dataValidation);
        }

        int i;
        if (columnHidden != null) {
            for(i = 0; i < columnHidden.length; ++i) {
                sheet.setColumnHidden(columnHidden[i], true);
            }
        }

        if (columnLength != null) {
            for(i = 0; i < columnLength.length; ++i) {
                sheet.setColumnWidth(i, columnLength[i]);
            }
        }

        Row row = sheet.createRow(0);

        for(int i = 0; titles != null && i < titles.length; ++i) {
            Cell cell = row.createCell(i);
            cell.setCellValue(titles[i]);
            cell.setCellStyle(cellStyleTitle);
        }

        CellStyle cellStyleBody = workbook.createCellStyle();
        cellStyleBody.cloneStyleFrom(cellStyleTitle);
        Font fontBody = workbook.createFont();
        fontBody.setFontName("宋体");
        fontBody.setFontHeightInPoints((short)10);
        cellStyleBody.setFont(fontBody);
        return workbook;
    }

    public static void writeExceleByPOI(SXSSFWorkbook sxssfWorkbook, OutputStream out) {
        try {
            sxssfWorkbook.write(out);
            out.flush();
        } catch (IOException var11) {
            log.error("系统异常:", var11);
        } finally {
            try {
                if (out != null) {
                    out.close();
                }

                sxssfWorkbook.dispose();
            } catch (IOException var10) {
                log.error("系统异常:", var10);
            }

        }

    }
}

然后导出即可

相关依赖

 <!--easypoi-->
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-base</artifactId>
            <version>4.1.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-web</artifactId>
            <version>4.1.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-annotation</artifactId>
            <version>4.1.0</version>
        </dependency>
        <!-- poi4.1.0 -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>4.1.0</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>4.1.0</version>
        </dependency>
        <!-- 使用模板excel导出功能 -->
        <dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls</artifactId>
            <version>2.8.1</version>
        </dependency>
        <dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls-poi</artifactId>
            <version>1.0.12</version>
        </dependency>
        <dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls-jexcel</artifactId>
            <version>1.0.9</version>
        </dependency>
        <!-- 大数据excel导出功能 -->
        <dependency>
            <groupId>antlr</groupId>
            <artifactId>antlr</artifactId>
            <version>2.7.7</version>
        </dependency>
        <dependency>
            <groupId>org.antlr</groupId>
            <artifactId>stringtemplate</artifactId>
            <version>3.2.1</version>
        </dependency>
        <!--pdf生成工具类-->
        <dependency>
            <groupId>com.itextpdf</groupId>
            <artifactId>itextpdf</artifactId>
            <version>5.4.2</version>
        </dependency>
        <dependency>
            <groupId>com.itextpdf.tool</groupId>
            <artifactId>xmlworker</artifactId>
            <version>5.4.1</version>
        </dependency>
        <dependency>
            <groupId>com.itextpdf</groupId>
            <artifactId>itext-asian</artifactId>
            <version>5.2.0</version>
        </dependency>
        <dependency>
            <groupId>org.xhtmlrenderer</groupId>
            <artifactId>flying-saucer-pdf</artifactId>
            <version>9.0.3</version>
        </dependency>
Easypoi导出功能
weixin_43762113的博客
11-24 319
Easypoi导出功能
easypoi导出工具
11-05
easypoi常用导入，导出，工具，引入easypoi包ExcelUtil工具类，可以直接导出查询的数据
easypoi导出
qq_1621633825的博客
08-27 276
1.首先导入相应依赖 <!-- easypoi简单导出所需要的jar包 start --> <dependency> <groupId>cn.afterturn</groupId> <artifactId>easypoi-base</artifactId> <version>3.2.0</version> </dependency> <dependency&gt
easypoi导出文件
m0_37908462的博客
07-22 672
easypoi+vue导出下载文件
EasyPoi导出
csdmwinter的博客
01-12 768
EasyPoi导出excel用户记录
easypoi 导出word并插入echart图片和文件
06-27
在本场景中，我们关注的是如何使用Easypoi导出Word文档，并且在这个文档中插入Echarts生成的图表以及附加文件。Echarts是一个流行的JavaScript数据可视化库，它提供了丰富的图表类型和强大的交互功能，常用于网页...
使用EasyPOI导出Excel模板数据（含图片）博文源码
09-25
这篇博文的源码提供了一个使用EasyPOI导出包含图片的Excel模板数据的示例，这在报表生成、数据分析和报告制作等场景中非常实用。 首先，我们来看看`ExcelTemplateExportUtil.java`，这个类是导出工具的核心，它实现...
若依使用easypoi导出word文档.docx
04-26
在本场景中，我们将探讨如何使用Easypoi库来实现导出Word文档的功能。Easypoi是一个强大的Java办公组件，能够方便地处理Excel和Word文档，尤其适合于数据批量导入导出和模板生成。 首先，我们需要在项目的`pom.xml`...
easyPOI导出.rar
07-18
【标题】"easyPOI导出.rar"是一个与Java编程相关的压缩包，它包含了使用easyPOI库进行Excel数据导出的功能。EasyPOI是一款基于Apache POI的简化版工具，用于处理Microsoft Office文档，尤其是Excel文件。在Java中，...
Easypoi导出
qq_40278285的博客
03-17 240
Easypoi导出maven添加编写工具类 maven添加 <!-- easypoi的支持 --> <!--easy poi http://easypoi.mydoc.io/#text_217736 https://gitee.com/lemur/easypoi--> <dependency> <groupId>cn.afterturn</groupId> &lt
easypoi，Excel导出导出
12-29
easypoi功能如同名字easy,主打的功能就是容易,让一个没见接触过poi的人员 就可以方便的写出Excel导出,Excel模板导出,Excel导入,Word模板导出,通过简单的注解和模板 语言(熟悉的表达式语法),完成以前复杂的写法
EasyPoi导出Excel表格
weixin —> Ryan-0713
11-03 564
导出Excel表格格式文件显示
使用EasyPoi导出Excel
热门推荐
qq_60676778的博客
07-14 1万+
springcloud导出easy poi，简单
easypoi导入导出
weixin_44900881的博客
01-31 436
【代码】easypoi导入导出。
easypoi导出功能
来一杯吧
11-22 478
<dependency> <groupId>cn.afterturn</groupId> <artifactId>easypoi-base</artifactId> <version>3.2.0</version> </dependency> <dependency> <groupId&gt.
Easypoi模板导出
最新发布
qq_26817225的博客
09-21 2569
Easypoi模板导出 优点 快速导出：使用预定义的Excel模板，可以快速导出数据，特别是在数据量大的情况下。 简化代码：通过模板导出，减少了编写大量POI代码的需要，使得代码更简洁易懂。 灵活性：模板可以根据需求进行自定义，可以包含复杂的格式和公式。 缺点 依赖性强：EasyPOI模板导出依赖于Apache POI库，如果没有这个库，它将无法工作。 模板维护：模板文件需要被维护，如果模板更改，可能需要重新生成模板文件。 限制性：模板导出的结果受限于模板的定义，不能完全自定义Excel文件的所有特性
easyPoi的简单导出操作
smallhide的博客
05-22 759
@小小鸟 esaypoi的导出 easypoi功能如同名字easy,主打的功能就是容易,让一个没见接触过poi的人员 就可以方便的写出Excel导出,Excel模板导出,Excel导入,Word模板导出,通过简单的注解和模板 语言(熟悉的表达式语法),完成以前复杂的写法。 @GetMapping(value = "/excelList", name = "导出需求数据") public void ExcelList(HttpServletRequest request, HttpServletRes
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值