本帖最后由 Clark.Pan 于 2021-8-20 17:32 编辑
gcexcel模板使用IF的公式在执行workbook.processTemplate()时就会报错，
请问是这种公式不支持吗，还是写法不对？有替换公式吗？
公式如下：
=IFERROR(IF(OR(AY3="是",AZ3="是",BA3="是"),"是","否"),"否")
=IF(AY3="是","是",IF(AZ3="是","是",IF(BA3="是","是","否")))
报错信息如下：
java.lang.IllegalArgumentException
at com.grapecity.documents.excel.A.ak.f(Unknown Source)
at com.grapecity.documents.excel.z.z.a(Unknown Source)
at com.grapecity.documents.excel.z.z.a(Unknown Source)
at com.grapecity.documents.excel.z.z.a(Unknown Source)
at com.grapecity.documents.excel.z.z.a(Unknown Source)
at com.grapecity.documents.excel.z.z.a(Unknown Source)
at com.grapecity.documents.excel.C.as.aj(Unknown Source)
at com.grapecity.documents.excel.Workbook.processTemplate(Unknown Source)
at com.midea.epm.platform.event.service.impl.CountGcExcelEventServiceImpl.processTemplate(CountGcExcelEventServiceImpl.java:286)
at com.midea.epm.platform.event.service.impl.CountGcExcelEventServiceImpl.countGcExcelEvent(CountGcExcelEventServiceImpl.java:145)
at com.midea.epm.platform.event.service.impl.CountGcExcelEventServiceImpl.doButtonEvent(CountGcExcelEventServiceImpl.java:76)
at com.midea.epm.platform.event.service.impl.CountGcExcelEventServiceImpl$$FastClassBySpringCGLIB$$6cc4d0.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at com.alibaba.druid.support.spring.stat.DruidStatInterceptor.invoke(DruidStatInterceptor.java:72)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
at com.midea.epm.platform.event.service.impl.CountGcExcelEventServiceImpl$$EnhancerBySpringCGLIB$$ef28c7c.doButtonEvent(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:223)
at com.midea.epm.platform.event.util.ButtonEventUtils.springInvokeExcelButtonEventMethod(ButtonEventUtils.java:46)
at com.midea.epm.platform.event.service.impl.BudSerialButtonEventServiceImpl.doInnerExcelButtonEventByEventInsId(BudSerialButtonEventServiceImpl.java:291)
at com.midea.epm.platform.event.service.impl.BudSerialButtonEventServiceImpl$$FastClassBySpringCGLIB$$223f4e49.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at com.alibaba.druid.support.spring.stat.DruidStatInterceptor.invoke(DruidStatInterceptor.java:72)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
at com.midea.epm.platform.event.service.impl.BudSerialButtonEventServiceImpl$$EnhancerBySpringCGLIB$$72ca1ec2.doInnerExcelButtonEventByEventInsId(<generated>)
at com.midea.epm.platform.controller.BudConfExcelButtonEventController.buttonEventInsExecutor(BudConfExcelButtonEventController.java:620)
at com.midea.epm.platform.controller.BudConfExcelButtonEventController.buttonEventInsExecutor(BudConfExcelButtonEventController.java:637)
at com.midea.epm.platform.controller.BudConfExcelButtonEventController.buildEventIns(BudConfExcelButtonEventController.java:494)
at com.midea.epm.platform.controller.BudConfExcelButtonEventController.listener(BudConfExcelButtonEventController.java:998)
at com.midea.epm.platform.controller.BudConfExcelButtonEventController$$FastClassBySpringCGLIB$$ee3be9c8.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115)
at org.springframework.aop.interceptor.AsyncExecutionInterceptor$$Lambda$594/1987892955.call(Unknown Source)
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
at java.util.concurrent.FutureTask.run(FutureTask.java)
at java.lang.Thread.run(Thread.java:745)
|
陕公网安备：61019002000258 |
隐私政策 |
网站地图