Java导出Excel的时候报sheetName must not be null？

[沙卡拉卡]

ERROR 2017-01-16 09:24:36,367 errorLogger {[message]=sheetName must not be null, [appServer]=, [msgId]=null, [stacktrace]=
	Caused by: java.lang.IllegalArgumentException: sheetName must not be null
		at org.apache.poi.ss.util.WorkbookUtil.validateSheetName(WorkbookUtil.java:131)
		at org.apache.poi.xssf.usermodel.XSSFWorkbook.setSheetName(XSSFWorkbook.java:1348)
		at com.lamp.base.util.excle.XLSXSheetUtil.fillData(XLSXSheetUtil.java:353)
		at com.lamp.base.util.excle.XLSXSheetUtil.fillData(XLSXSheetUtil.java:525)
		at com.lamp.base.util.excle.ExcelSheetUtil.fillData(ExcelSheetUtil.java:52)
		at com.lamp.lease.logic.acc.impl.Acc0009r99LogicImpl.printAcc0009r99(Acc0009r99LogicImpl.java:426)
		at com.lamp.lease.logic.acc.impl.Acc0009r99LogicImpl.doExecute(Acc0009r99LogicImpl.java:399)
		at com.lamp.lease.logic.acc.impl.Acc0009r99LogicImpl$$EnhancedByS2AOP$$686a2d59.$$doExecute$$invokeSuperMethod$$(Acc0009r99LogicImpl$$EnhancedByS2AOP$$686a2d59.java)
		at com.lamp.lease.logic.acc.impl.Acc0009r99LogicImpl$$EnhancedByS2AOP$$686a2d59$$MethodInvocation$$doExecute0.proceed(MethodInvocationClassGenerator.java)
		at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:73)
		at com.lamp.lease.logic.acc.impl.Acc0009r99LogicImpl$$EnhancedByS2AOP$$686a2d59$$MethodInvocation$$doExecute0.proceed(MethodInvocationClassGenerator.java)
		at com.lamp.lease.logic.acc.impl.Acc0009r99LogicImpl$$EnhancedByS2AOP$$686a2d59.doExecute(Acc0009r99LogicImpl$$EnhancedByS2AOP$$686a2d59.java)
		at com.lamp.lease.logic.ctr.impl.Ctr0002s01LogicImpl.doAccountingWithdrawInfo(Ctr0002s01LogicImpl.java:1778)
		at com.lamp.lease.logic.ctr.impl.Ctr0002s01LogicImpl$$EnhancedByS2AOP$$7f000a53.$$doAccountingWithdrawInfo$$invokeSuperMethod$$(Ctr0002s01LogicImpl$$EnhancedByS2AOP$$7f000a53.java)
		at com.lamp.lease.logic.ctr.impl.Ctr0002s01LogicImpl$$EnhancedByS2AOP$$7f000a53$$MethodInvocation$$doAccountingWithdrawInfo6.proceed(MethodInvocationClassGenerator.java)
		at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:73)
		at com.lamp.lease.logic.ctr.impl.Ctr0002s01LogicImpl$$EnhancedByS2AOP$$7f000a53$$MethodInvocation$$doAccountingWithdrawInfo6.proceed(MethodInvocationClassGenerator.java)
		at com.lamp.lease.logic.ctr.impl.Ctr0002s01LogicImpl$$EnhancedByS2AOP$$7f000a53.doAccountingWithdrawInfo(Ctr0002s01LogicImpl$$EnhancedByS2AOP$$7f000a53.java)
		at com.lamp.lease.service.ctr.impl.Ctr0002s01ServiceImpl.doAccountingWithdrawInfo(Ctr0002s01ServiceImpl.java:256)
		at com.lamp.lease.service.ctr.impl.Ctr0002s01ServiceImpl$$EnhancedByS2AOP$$375fae6.$$doAccountingWithdrawInfo$$invokeSuperMethod$$(Ctr0002s01ServiceImpl$$EnhancedByS2AOP$$375fae6.java)
		at com.lamp.lease.service.ctr.impl.Ctr0002s01ServiceImpl$$EnhancedByS2AOP$$375fae6$$MethodInvocation$$doAccountingWithdrawInfo7.proceed(MethodInvocationClassGenerator.java)
		at org.seasar.extension.tx.DefaultTransactionCallback.execute(DefaultTransactionCallback.java:58)
		at org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATransactionManagerAdapter.java:65)
		at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:50)
		at com.lamp.lease.service.ctr.impl.Ctr0002s01ServiceImpl$$EnhancedByS2AOP$$375fae6$$MethodInvocation$$doAccountingWithdrawInfo7.proceed(MethodInvocationClassGenerator.java)
		at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:73)
		at com.lamp.lease.service.ctr.impl.Ctr0002s01ServiceImpl$$EnhancedByS2AOP$$375fae6$$MethodInvocation$$doAccountingWithdrawInfo7.proceed(MethodInvocationClassGenerator.java)
		at com.lamp.lease.service.ctr.impl.Ctr0002s01ServiceImpl$$EnhancedByS2AOP$$375fae6.doAccountingWithdrawInfo(Ctr0002s01ServiceImpl$$EnhancedByS2AOP$$375fae6.java)
		at com.lamp.lease.web.ctr.Ctr0002s01Page.doAccountingWithdrawInfo(Ctr0002s01Page.java:1996)
		at com.lamp.lease.web.ctr.Ctr0002s01Page$$EnhancedByS2AOP$$2442bb74.$$doAccountingWithdrawInfo$$invokeSuperMethod$$(Ctr0002s01Page$$EnhancedByS2AOP$$2442bb74.java)
		at com.lamp.lease.web.ctr.Ctr0002s01Page$$EnhancedByS2AOP$$2442bb74$$MethodInvocation$$doAccountingWithdrawInfo10.proceed(MethodInvocationClassGenerator.java)
		at com.lamp.base.util.interceptor.ActionLockIntercepter.invoke(ActionLockIntercepter.java:70)
		at com.lamp.lease.web.ctr.Ctr0002s01Page$$EnhancedByS2AOP$$2442bb74$$MethodInvocation$$doAccountingWithdrawInfo10.proceed(MethodInvocationClassGenerator.java)
		at com.lamp.base.util.interceptor.LoggingIntercepter.processPageAction(LoggingIntercepter.java:96)
		at com.lamp.base.util.interceptor.LoggingIntercepter.invoke(LoggingIntercepter.java:62)
		at com.lamp.lease.web.ctr.Ctr0002s01Page$$EnhancedByS2AOP$$2442bb74$$MethodInvocation$$doAccountingWithdrawInfo10.proceed(MethodInvocationClassGenerator.java)
		at com.lamp.base.util.interceptor.ActionIntercepter.invoke(ActionIntercepter.java:81)
		at com.lamp.lease.web.ctr.Ctr0002s01Page$$EnhancedByS2AOP$$2442bb74$$MethodInvocation$$doAccountingWithdrawInfo10.proceed(MethodInvocationClassGenerator.java)
		at org.seasar.framework.aop.interceptors.ThrowsInterceptor.invoke(ThrowsInterceptor.java:79)
		at com.lamp.lease.web.ctr.Ctr0002s01Page$$EnhancedByS2AOP$$2442bb74$$MethodInvocation$$doAccountingWithdrawInfo10.proceed(MethodInvocationClassGenerator.java)
		at com.lamp.base.util.interceptor.AuthorityCheckIntercepter.invoke(AuthorityCheckIntercepter.java:90)
		at com.lamp.lease.web.ctr.Ctr0002s01Page$$EnhancedByS2AOP$$2442bb74$$MethodInvocation$$doAccountingWithdrawInfo10.proceed(MethodInvocationClassGenerator.java)
		at com.lamp.base.util.interceptor.ManualURLIntercepter.invoke(ManualURLIntercepter.java:136)
		at com.lamp.lease.web.ctr.Ctr0002s01Page$$EnhancedByS2AOP$$2442bb74$$MethodInvocation$$doAccountingWithdrawInfo10.proceed(MethodInvocationClassGenerator.java)
		at org.seasar.framework.aop.interceptors.ThrowsInterceptor.invoke(ThrowsInterceptor.java:79)
		at com.lamp.lease.web.ctr.Ctr0002s01Page$$EnhancedByS2AOP$$2442bb74$$MethodInvocation$$doAccountingWithdrawInfo10.proceed(MethodInvocationClassGenerator.java)
		at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:73)
		at com.lamp.lease.web.ctr.Ctr0002s01Page$$EnhancedByS2AOP$$2442bb74$$MethodInvocation$$doAccountingWithdrawInfo10.proceed(MethodInvocationClassGenerator.java)
		at com.lamp.lease.web.ctr.Ctr0002s01Page$$EnhancedByS2AOP$$2442bb74.doAccountingWithdrawInfo(Ctr0002s01Page$$EnhancedByS2AOP$$2442bb74.java)
		at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
		at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
		at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
		at java.lang.reflect.Method.invoke(Method.java:606)
		at org.seasar.framework.util.MethodUtil.invoke(MethodUtil.java:96)
		at org.seasar.framework.beans.impl.BeanDescImpl.invoke(BeanDescImpl.java:218)
		at org.seasar.teeda.extension.html.impl.HtmlComponentInvokerImpl.invoke(HtmlComponentInvokerImpl.java:163)
		at org.seasar.teeda.extension.html.impl.HtmlActionListener.processAction(HtmlActionListener.java:71)
		at javax.faces.component.UICommand.broadcast(UICommand.java:149)
		at org.seasar.teeda.extension.component.html.THtmlCommandButton.broadcast(THtmlCommandButton.java:78)
		at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:192)
		at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:117)
		at org.seasar.teeda.core.lifecycle.impl.InvokeApplicationPhase.executePhase(InvokeApplicationPhase.java:29)
		at org.seasar.teeda.core.lifecycle.AbstractPhase.execute(AbstractPhase.java:57)
		at org.seasar.teeda.core.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:97)
		at javax.faces.webapp.FacesServlet.service(FacesServlet.java:100)
		at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
		at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
		at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
		at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
		at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
		at com.lamp.base.util.filter.LoginFilter.doFilter(LoginFilter.java:167)
		at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
		at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
		at org.seasar.framework.container.hotdeploy.HotdeployFilter.doFilter(HotdeployFilter.java:71)
		at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
		at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
		at org.seasar.framework.container.filter.S2ContainerFilter.doFilter(S2ContainerFilter.java:79)
		at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
		at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
		at org.seasar.teeda.extension.filter.MultipartFormDataFilter.doFilter(MultipartFormDataFilter.java:83)
		at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
		at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
		at org.seasar.extension.filter.EncodingFilter.doFilter(EncodingFilter.java:69)
		
		
		

我的Excel里有sheet名啊，怎么会报这个错误？

[老鼠拧刀满街找猫]

这种问题你可以断点看一下是不是逻辑的问题，比如sheetname赋值了多次，有些是null，有些非空

[xiesisi3]

用的JXL？ 打印一下sheetName先 单步调试一下

[沙卡拉卡]

引用 1 楼 xiesisi3 的回复:

用的JXL？
打印一下sheetName先
单步调试一下

用的是poi

单步调试sheetName为null，咋整~~

[xiesisi3]

你这个说明太少了 http://blog.csdn.net/jerehedu/article/details/45195359 自己看着例子写吧

[咸鱼斯内克]

要么就直接定义sheet名称吧 createSheet(sheetName);