poi版本问题报错
原代码jar用的是poi-3.16版本的导出没问题,升级成poi-3.17这个代码就会报错
// 计划单列表数据
List<PurchasingApplicationItemVo> list = priceComparisonService.downloadExcel(pramMap);
Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), PurchasingApplicationItemVo.class, list);
workbook.write(response.getOutputStream());
改成以下代码就没问题了
// 计划单列表数据
List<PurchasingApplicationItemVo> list = priceComparisonService.downloadExcel(pramMap);
ExportParams exportParams = new ExportParams();
exportParams.setStyle(ExcelStyleUtil.class);
Workbook workbook = ExcelExportUtil.exportExcel(exportParams, PurchasingApplicationItemVo.class, list);
workbook.write(response.getOutputStream());
报错原因:
导出的Excel没有设置样式poi-3.17就会报错