栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

easypoi 4.4 导出

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

easypoi 4.4 导出

普通导出

普通导出,大数据下会内存溢出

    @ApiOperation(value = "导出订单")
    @RequestMapping(value = "/export_order", method = RequestMethod.GET)
    public void exportOrderList(SearchOrder searchParam,ModelMap map, HttpServletRequest request, HttpServletResponse response) {
        var result = orderService.searchOrderList(searchParam);
        ExportParams params = new ExportParams(null, "Sheet1", ExcelType.XSSF);
        params.setStyle(EasyPoiStyleUtil.class);
        map.put(NormalExcelConstants.DATA_LIST, result);
        map.put(NormalExcelConstants.CLASS, ExportOrderInfoDto.class);
        map.put(NormalExcelConstants.PARAMS, params);
        map.put(NormalExcelConstants.FILE_NAME, "订单列表");
        PoiBaseView.render(map, request, response, NormalExcelConstants.EASYPOI_EXCEL_VIEW);
    }
大数据导出
	@ApiOperation(value = "导出订单")
    @RequestMapping(value = "/export_order", method = RequestMethod.GET)
    public void exportOrderList(SearchOrder searchParam,HttpServletResponse response) {
        var result = orderService.searchOrderList(searchParam);
        //分别是totalPage是总页数,pageSize 页码长度
        int totalPage = (result.size() / 10000) + 1;
        int pageSize = 10000;
        String fileName="订单列表";
        ExportParams exportParams = new ExportParams();
        Workbook workbook = null;
        workbook = ExcelExportUtil.exportBigExcel(exportParams, ExportOrderInfoDto.class, new IExcelExportServer() {
            @Override
            public List selectListForExcelExport(Object obj, int page) {
                //将所有的数据List分批返回处理,最大每批10000
                if (page > totalPage) {
                    return null;
                }
                //fromIndex开始索引,toIndex结束索引
                int fromIndex = (page - 1) * pageSize;
                int toIndex = page != totalPage ? fromIndex + pageSize :result.size();
                List list = new ArrayList<>();
                list.addAll(result.subList(fromIndex, toIndex));
                return list;
            }
        }, totalPage);
        try {
            EasyPoiUtil.downLoadExcel(fileName,response, workbook);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }


转载请注明:文章转载自 www.mshxw.com
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号