Hello,
I have problem to read xlsx which contain a cell formatted by Underline.
The xlsx file is a report which user will download from somewhere.
Please provide help.
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
[22/02/11 13:29:16:299 EST] 00000418 SystemOut O Caused by:
org.apache.poi.openxml4j.exceptions.InvalidFormatException: Package
should contain a content type part [M1.13]
at
org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:147
)
at
org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:592)
at
org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:222)
at org.apache.poi.util.PackageHelper.open(PackageHelper.java:39)
at
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:186)
at
ca.on.gov.gsdc.easy.popm.web.dto.DeptHierarchyXssfProcessor.displayCellC
ontents(DeptHierarchyXssfProcessor.java:62)
at
ca.on.gov.gsdc.easy.popm.web.portlet.controller.CisDeptRollupController.
uploadSubmit(CisDeptRollupController.java:65)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:79)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.doI
nvokeMethod(HandlerMethodInvoker.java:710)
at
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.inv
okeHandlerMethod(HandlerMethodInvoker.java:167)
at
org.springframework.web.portlet.mvc.annotation.AnnotationMethodHandlerAd
apter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:349)
at
org.springframework.web.portlet.mvc.annotation.AnnotationMethodHandlerAd
apter.doHandle(AnnotationMethodHandlerAdapter.java:337)
at
org.springframework.web.portlet.mvc.annotation.AnnotationMethodHandlerAd
apter.handleAction(AnnotationMethodHandlerAdapter.java:277)
at
org.springframework.web.portlet.DispatcherPortlet.doActionService(Dispat
cherPortlet.java:646)
at
org.springframework.web.portlet.FrameworkPortlet.processRequest(Framewor
kPortlet.java:519)
at
org.springframework.web.portlet.FrameworkPortlet.processAction(Framework
Portlet.java:460)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletFilterChainImpl.doFilter
(PortletFilterChainImpl.java:77)
at
com.ibm.wps.propertybroker.standard.filter.PropertyBrokerActionFilter.do
Filter(PropertyBrokerActionFilter.java:731)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletFilterChainImpl.doFilter
(PortletFilterChainImpl.java:69)
at
com.ibm.wps.propertybroker.standard.filter.C2APortletFilter.doFilter(C2A
PortletFilter.java:166)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletFilterChainImpl.doFilter
(PortletFilterChainImpl.java:69)
at
com.ibm.wps.engine.dpr.portlet.impl.ProcessActionMemoFilter.doFilter(Pro
cessActionMemoFilter.java:88)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletFilterChainImpl.doFilter
(PortletFilterChainImpl.java:69)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletServlet.doDispatch(Portl
etServlet.java:527)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletServletCollaboratorChain
Impl.doCollaborator(PortletServletCollaboratorChainImpl.java:114)
at
com.ibm.isclite.container.collaborator.PortletServletCollaborator.doActi
on(PortletServletCollaborator.java:57)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletServletCollaboratorChain
Impl.doCollaborator(PortletServletCollaboratorChainImpl.java:101)
at
com.ibm.ws.portletcontainer.rrd.RRDServerPortletServletCollaborator.doAc
tion(RRDServerPortletServletCollaborator.java:117)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletServletCollaboratorChain
Impl.doCollaborator(PortletServletCollaboratorChainImpl.java:101)
at
com.ibm.ws.portletcontainer.cache.CacheCollaborator.doAction(CacheCollab
orator.java:84)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletServletCollaboratorChain
Impl.doCollaborator(PortletServletCollaboratorChainImpl.java:101)
at
com.ibm.wps.pe.pc.waspc.core.impl.PortletServletCollaboratorImpl.doActio
n(PortletServletCollaboratorImpl.java:146)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletServletCollaboratorChain
Impl.doCollaborator(PortletServletCollaboratorChainImpl.java:101)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletServlet.doDispatch(Portl
etServlet.java:301)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletServletCollaboratorChain
Impl.doCollaborator(PortletServletCollaboratorChainImpl.java:82)
at
com.ibm.isclite.container.collaborator.PortletServletCollaborator.doDisp
atch(PortletServletCollaborator.java:136)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletServletCollaboratorChain
Impl.doCollaborator(PortletServletCollaboratorChainImpl.java:74)
at
com.ibm.ws.portletcontainer.rrd.RRDServerPortletServletCollaborator.doDi
spatch(RRDServerPortletServletCollaborator.java:60)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletServletCollaboratorChain
Impl.doCollaborator(PortletServletCollaboratorChainImpl.java:74)
at
com.ibm.ws.portletcontainer.cache.CacheCollaborator.doDispatch(CacheColl
aborator.java:74)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletServletCollaboratorChain
Impl.doCollaborator(PortletServletCollaboratorChainImpl.java:74)
at
com.ibm.wps.pe.pc.waspc.core.impl.PortletServletCollaboratorImpl.doDispa
tch(PortletServletCollaboratorImpl.java:121)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletServletCollaboratorChain
Impl.doCollaborator(PortletServletCollaboratorChainImpl.java:74)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletServlet.dispatch(Portlet
Servlet.java:208)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletServlet.service(PortletS
ervlet.java:165)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.ja
va:1146)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.ja
va:1087)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:118)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterC
hain.java:87)
at
com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilter
Manager.java:848)
at
com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilter
Manager.java:691)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrap
per.java:588)
at
com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWr
apper.java:525)
at
com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(G
enericServletWrapper.java:122)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppReq
uestDispatcher.java:639)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletInvokerImpl.invoke(Portl
etInvokerImpl.java:235)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletInvokerCollaboratorChain
Impl.doCollaborator(PortletInvokerCollaboratorChainImpl.java:76)
at
com.ibm.ws.portletcontainer.cache.PortletInvokerCacheCollaborator.doActi
on(PortletInvokerCacheCollaborator.java:50)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletInvokerCollaboratorChain
Impl.doCollaborator(PortletInvokerCollaboratorChainImpl.java:65)
at
com.ibm.ws.portletcontainer.ext.PortletInvokerPerformanceCollaborator.in
voke(PortletInvokerPerformanceCollaborator.java:313)
at
com.ibm.ws.portletcontainer.ext.PortletInvokerPerformanceCollaborator.do
Invoke(PortletInvokerPerformanceCollaborator.java:101)
at
com.ibm.ws.portletcontainer.ext.PortletInvokerPerformanceCollaborator.in
vokePMI(PortletInvokerPerformanceCollaborator.java:163)
at
com.ibm.ws.portletcontainer.ext.PortletInvokerPerformanceCollaborator.do
Invoke(PortletInvokerPerformanceCollaborator.java:91)
at
com.ibm.ws.portletcontainer.ext.PortletInvokerPerformanceCollaborator.do
Action(PortletInvokerPerformanceCollaborator.java:62)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletInvokerCollaboratorChain
Impl.doCollaborator(PortletInvokerCollaboratorChainImpl.java:65)
at
com.ibm.ws.portletcontainer.invoker.impl.PortletInvokerImpl.action(Portl
etInvokerImpl.java:77)
at
com.ibm.ws.portletcontainer.PortletContainerImpl.doAction(PortletContain
erImpl.java:188)
at
com.ibm.ws.portletcontainer.PortletContainerInvokerCollaboratorChainImpl
.doCollaborator(PortletContainerInvokerCollaboratorChainImpl.java:78)
at
com.ibm.ws.portletcontainer.ext.ExtCollaborator.doAction(ExtCollaborator
.java:54)
at
com.ibm.ws.portletcontainer.PortletContainerInvokerCollaboratorChainImpl
.doCollaborator(PortletContainerInvokerCollaboratorChainImpl.java:65)
at
com.ibm.ws.portletcontainer.cache.CacheInvokerCollaborator.doAction(Cach
eInvokerCollaborator.java:76)
at
com.ibm.ws.portletcontainer.PortletContainerInvokerCollaboratorChainImpl
.doCollaborator(PortletContainerInvokerCollaboratorChainImpl.java:65)
at
com.ibm.ws.portletcontainer.PortletContainerImpl.processPortletAction(Po
rtletContainerImpl.java:154)
at
com.ibm.ws.portletcontainer.pcinvoker.PortletInvokerImpl$1.run(PortletIn
vokerImpl.java:59)
at
java.security.AccessController.doPrivileged(AccessController.java:241)
at
com.ibm.ws.portletcontainer.pcinvoker.PortletInvokerImpl.invokeProcessAc
tion(PortletInvokerImpl.java:55)
at
com.ibm.wps.pe.pc.waspc.core.impl.PortletInvokerImpl$3.invoke(PortletInv
okerImpl.java:121)
at
com.ibm.wps.pe.pc.waspc.core.impl.PortletInvokerImpl.invoke(PortletInvok
erImpl.java:181)
at
com.ibm.wps.pe.pc.waspc.core.impl.PortletInvokerImpl.invokeProcessAction
(PortletInvokerImpl.java:119)
at
com.ibm.wps.pe.pc.waspc.event.ActionEvent.execute(ActionEvent.java:78)
at
com.ibm.wps.pe.pc.waspc.event.EventQueueManager.processEventLoop(EventQu
eueManager.java:112)
at
com.ibm.wps.pe.pc.waspc.PortletContainerImpl.performEvents(PortletContai
nerImpl.java:206)
at
com.ibm.wps.pe.pc.PortletContainerImpl.performEvents(PortletContainerImp
l.java:298)
at
com.ibm.wps.engine.phases.WPActionPhase.processPortlets(WPActionPhase.ja
va:2667)
at
com.ibm.wps.engine.phases.WPActionPhase.execute(WPActionPhase.java:668)
at
com.ibm.wps.state.phases.AbstractActionPhase.next(AbstractActionPhase.ja
va:130)
at com.ibm.wps.engine.Servlet.callPortal(Servlet.java:855)
at com.ibm.wps.engine.Servlet.doGet(Servlet.java:617)
at com.ibm.wps.engine.Servlet.doPost(Servlet.java:888)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at com.ibm.wps.engine.Servlet.doFilter(Servlet.java:1257)
at
com.ibm.wps.resolver.servlet.ContentHandlerCleanup.doFilter(ContentHandl
erCleanup.java:648)
at
com.ibm.wps.resolver.servlet.AbstractFilter.doFilter(AbstractFilter.java
:93)
at com.ibm.wps.engine.Servlet.service(Servlet.java:1248)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.ja
va:1146)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.ja
va:1087)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:145)
at
com.ibm.wps.engine.ExtendedLocaleFilter.doFilter(ExtendedLocaleFilter.ja
va:113)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInst
anceWrapper.java:190)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:130)
at
com.ibm.wps.resolver.friendly.servlet.FriendlySelectionFilter.doFilter(F
riendlySelectionFilter.java:191)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInst
anceWrapper.java:190)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:130)
at
com.ibm.wps.mappingurl.impl.URLAnalyzer.doFilter(URLAnalyzer.java:381)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInst
anceWrapper.java:190)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:130)
at
com.ibm.wps.engine.VirtualPortalFilter.doFilter(VirtualPortalFilter.java
:88)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInst
anceWrapper.java:190)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:130)
at
com.ibm.wps.state.filter.StateCleanup.doFilter(StateCleanup.java:94)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInst
anceWrapper.java:190)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
ain.java:130)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterC
hain.java:87)
at
com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilter
Manager.java:848)
at
com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilter
Manager.java:691)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrap
per.java:588)
at
com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWr
apper.java:525)
at
com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3548)
at
com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:269)
at
com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:831
)
at
com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1
478)
at
com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:1
33)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscriminatio
n(HttpInboundLink.java:450)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(Ht
tpInboundLink.java:508)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(Http
InboundLink.java:296)
at
com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpIC
LReadCallback.java:102)
at
com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(Ai
oReadCompletionListener.java:165)
at
com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.
java:217)
at
com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFu
ture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196)
at
com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java
:751)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
[22/02/11 13:29:16:299 EST] 00000418 SystemOut O at
org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:147
)
[22/02/11 13:29:16:299 EST] 00000418 SystemOut O at
org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:592)
[22/02/11 13:29:16:299 EST] 00000418 SystemOut O at
org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:222)
[22/02/11 13:29:16:299 EST] 00000418 SystemOut O at
org.apache.poi.util.PackageHelper.open(PackageHelper.java:39)
[22/02/11 13:29:16:299 EST] 00000418 SystemOut O ... 134 more
Thanks,
Patty Ma
Senior Developer
CCAS Applications
Government Services Cluster
phone: 416-325-8286
cell: 416-526-7284
email: [email protected] <mailto:[email protected]>
