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


