天天看点

easy poi导出报错:cn.afterturn.easypoi.exception.excel.ExcelExportException: Excel导出错误

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就会报错