POI异常之NumberFormatException

最新推荐文章于 2022-08-18 09:45:51 发布

麦兜南宫

最新推荐文章于 2022-08-18 09:45:51 发布

阅读量906

点赞数

文章标签： Java POI Excel

本文链接：https://blog.csdn.net/yanlici1249075710/article/details/88797926

版权

2019-03-25 15:12:19,908 INFO  ~ 查询列表总用时 ：73
java.lang.NumberFormatException: For input string: "审核通过"
	at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1224)
	at java.lang.Double.parseDouble(Double.java:510)
	at utils.ExportExcelUtil.createCenter(ExportExcelUtil.java:187)
	at utils.ExportExcelUtil.createExcel(ExportExcelUtil.java:77)
	at bp.ExcelBaseBP.exportExcel(ExcelBaseBP.java:200)
	at controllers.remote.phptojava.GoodsList.GoodListController.goodExcel(GoodListController.java:249)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at play.mvc.ActionInvoker.invokeWithContinuation(ActionInvoker.java:682)
	at play.mvc.ActionInvoker.invoke(ActionInvoker.java:640)
	at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:616)
	at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:611)
	at play.mvc.ActionInvoker.invoke(ActionInvoker.java:174)
	at play.server.PlayHandler$NettyInvocation.execute(PlayHandler.java:237)
	at play.Invoker$Invocation.run(Invoker.java:264)
	at play.server.PlayHandler$NettyInvocation.run(PlayHandler.java:217)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)

上面的问题原因就是因为，使用POI导出Excel自动匹配参数列表的时候，匹配的参数列表为null，这样就导致无法跟参数列表匹配，所以就有问题了