普通导出,大数据下会内存溢出
@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