附踩坑记录我用EasyExcel优化了公司的导出( 二 ) _生活百科

版本不对的时候写入直接报错。异常信息如下：
Exception in thread "main" com.alibaba.excel.exception.ExcelGenerateException: java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.setCellValue(Ljava/time/LocalDateTime;)V at com.alibaba.excel.write.ExcelBuilderImpl.addContent(ExcelBuilderImpl.java:65) at com.alibaba.excel.ExcelWriter.write(ExcelWriter.java:70) at com.alibaba.excel.ExcelWriter.write(ExcelWriter.java:47) at cn.jojo.sales.app.task.ExportSalesTransferSummaryTask.main(ExportSalesTransferSummaryTask.java:90)Caused by: java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.setCellValue(Ljava/time/LocalDateTime;)V at com.alibaba.excel.write.executor.AbstractExcelWriteExecutor.converterAndSet(AbstractExcelWriteExecutor.java:95) at com.alibaba.excel.write.executor.ExcelWriteAddExecutor.addJavaObjectToExcel(ExcelWriteAddExecutor.java:174) at com.alibaba.excel.write.executor.ExcelWriteAddExecutor.addOneRowOfDataToExcel(ExcelWriteAddExecutor.java:82) at com.alibaba.excel.write.executor.ExcelWriteAddExecutor.add(ExcelWriteAddExecutor.java:58) at com.alibaba.excel.write.ExcelBuilderImpl.addContent(ExcelBuilderImpl.java:59) ... 3 more

excelWriter 要关闭

excelWriter.close();我之前因为 excelWriter 的定义是是写在 try 里的，所以没有 close，但是我的用法又是将 excelWriter 写入到字节流，然后字节流传到 oss，而且这个步骤也是在 try 里面。就导致了我一直写入不成功，后来才发现，浪费了一点时间。
【附踩坑记录我用EasyExcel优化了公司的导出】