POI 导出excel 时Cannot get a error value from a numeric cell

2013-12-25 09:03:23 1.1k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

LCG454872006 墨衍会员 · AI 创作全网分发关注 + 加入社区

Tesseract-Ocr踩坑下载以及进行检验 1 OCR，即Optical Character Recognition：光学字符识别，是指通过扫描字符，然后通过其形状将其翻译成电子文本的过程。下载完成后进行解压找到这两个，然后复制到之前下载Tesseract-Ocr的tessdata文件下。可能会出现报错说chi下载的问题咱们不用管继续ok让它先下载完毕，后续会有下载chi的步骤。四、检验tesseract使用（将以下图片进行下载我这里将以下图片命名为3.png）我这里选的是2024年的版本如果下载不了；4 在安装的时候（找到下载的exe文件，双击）阅读详情



java.lang.IllegalStateException: Cannot get a error value from a numeric cell

	at org.apache.poi.xssf.streaming.SXSSFCell.typeMismatch(SXSSFCell.java:845)

	at org.apache.poi.xssf.streaming.SXSSFCell.getErrorCellValue(SXSSFCell.java:487)

	at org.apache.poi.xssf.streaming.SXSSFCell.convertCellValueToString(SXSSFCell.java:895)

	at org.apache.poi.xssf.streaming.SXSSFCell.setType(SXSSFCell.java:764)

	at org.apache.poi.xssf.streaming.SXSSFCell.ensureType(SXSSFCell.java:721)

	at org.apache.poi.xssf.streaming.SXSSFCell.setCellType(SXSSFCell.java:106)

	at com.zx.common.utils.msoffice.NewExcelHandle$StyleUtil.setCellValue(NewExcelHandle.java:222)

	at com.zx.common.utils.msoffice.NewExcelHandle$StyleUtil.setCellBorder(NewExcelHandle.java:456)

	at com.zx.outstock.service.OutStockService.WriteExcelFirstOutStockPhone(OutStockService.java:346)

	at com.zx.outstock.service.OutStockService.expAllLedgerDo(OutStockService.java:1495)

	at com.zx.outstock.service.OutStockService$$FastClassByCGLIB$$2fa33f31.invoke(<generated>)

	at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)

	at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)

	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)

	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

	at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)

	at com.zx.outstock.service.OutStockService$$EnhancerByCGLIB$$fbba495b.expAllLedgerDo(<generated>)