You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@wicket.apache.org by grazia <Gr...@gmail.com> on 2013/06/12 04:24:19 UTC

bug in TableComponentAsXlsHandler


I am using the wicket poi api to generate an excel file from a
PageableListView.
I just run into a bug in lines 67-76 of TableComponentAsXlsHandler.java:
cellExplorer becomes null already at the second iteration of the for loop
(see below)

TableParser parser = new TableParser(newSheet(), cellExporter);
            if (tableComponent instanceof IPageable)
            {
                IPageable pageable = (IPageable)tableComponent;
                for (int i = 0; i < pageable.getPageCount(); i++)
                {
                    pageable.setCurrentPage(i);
                    parser.parse(tableComponent);
                }
            }

and we get  a NullPointerException  on line
org.wicketstuff.poi.excel.TableParser.doParse(TableParser.java:152) (see
below)

Do you have any suggestions on how to solve this problem ? 
I am using wicket-poi-1.5-RC5.1.jar



SEVERE: Unexpected error occurred
java.lang.RuntimeException: Error while generating a xls file to table
component
    at
org.wicketstuff.poi.excel.TableComponentAsXlsHandler.respond(TableComponentAsXlsHandler.java:91)
    at
org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:781)
    at
org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:64)
    at
org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:97)
    at
org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:255)
    at
org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:212)
    at
org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:283)
    at
org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:162)
    at
org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:218)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at
org.apache.catalina.core.StandardContextValve.__invoke(StandardContextValve.java:123)
    at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java)
    at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at
org.apache.catalina.core.StandardHostValve.__invoke(StandardHostValve.java:171)
    at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java)
    at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:931)
    at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
    at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
    at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
    at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:722)
Caused by: java.lang.NullPointerException
    at org.wicketstuff.poi.excel.TableParser.doParse(TableParser.java:152)
    at org.wicketstuff.poi.excel.TableParser.parse(TableParser.java:76)
    at
org.wicketstuff.poi.excel.TableComponentAsXlsHandler.respond(TableComponentAsXlsHandler.java:74)
    ... 26 more



--
View this message in context: http://apache-wicket.1842946.n4.nabble.com/bug-in-TableComponentAsXlsHandler-tp4659409.html
Sent from the Users forum mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
For additional commands, e-mail: users-help@wicket.apache.org


Re: bug in TableComponentAsXlsHandler

Posted by Martin Grigorov <mg...@apache.org>.
Hi,


On Wed, Jun 12, 2013 at 5:24 AM, grazia <Gr...@gmail.com>wrote:

>
>
> I am using the wicket poi api to generate an excel file from a
> PageableListView.
> I just run into a bug in lines 67-76 of TableComponentAsXlsHandler.java:
> cellExplorer becomes null already at the second iteration of the for loop
> (see below)
>
> TableParser parser = new TableParser(newSheet(), cellExporter);
>             if (tableComponent instanceof IPageable)
>             {
>                 IPageable pageable = (IPageable)tableComponent;
>                 for (int i = 0; i < pageable.getPageCount(); i++)
>                 {
>                     pageable.setCurrentPage(i);
>                     parser.parse(tableComponent);
>                 }
>             }
>
> and we get  a NullPointerException  on line
> org.wicketstuff.poi.excel.TableParser.doParse(TableParser.java:152) (see
> below)
>
> Do you have any suggestions on how to solve this problem ?
> I am using wicket-poi-1.5-RC5.1.jar
>

You may try with a newer version. The last is 1.5.10


>
>
>
> SEVERE: Unexpected error occurred
> java.lang.RuntimeException: Error while generating a xls file to table
> component
>     at
>
> org.wicketstuff.poi.excel.TableComponentAsXlsHandler.respond(TableComponentAsXlsHandler.java:91)
>     at
>
> org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:781)
>     at
>
> org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:64)
>     at
>
> org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:97)
>     at
> org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:255)
>     at
>
> org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:212)
>     at
>
> org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:283)
>     at
>
> org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:162)
>     at
>
> org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:218)
>     at
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
>     at
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>     at
>
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>     at
>
> org.apache.catalina.core.StandardContextValve.__invoke(StandardContextValve.java:123)
>     at
>
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java)
>     at
>
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
>     at
>
> org.apache.catalina.core.StandardHostValve.__invoke(StandardHostValve.java:171)
>     at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java)
>     at
>
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>     at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:931)
>     at
>
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>     at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
>     at
>
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
>     at
>
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>     at
>
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>     at
>
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>     at
>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>     at java.lang.Thread.run(Thread.java:722)
> Caused by: java.lang.NullPointerException
>     at org.wicketstuff.poi.excel.TableParser.doParse(TableParser.java:152)
>     at org.wicketstuff.poi.excel.TableParser.parse(TableParser.java:76)
>     at
>
> org.wicketstuff.poi.excel.TableComponentAsXlsHandler.respond(TableComponentAsXlsHandler.java:74)
>     ... 26 more
>
>
>
> --
> View this message in context:
> http://apache-wicket.1842946.n4.nabble.com/bug-in-TableComponentAsXlsHandler-tp4659409.html
> Sent from the Users forum mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
> For additional commands, e-mail: users-help@wicket.apache.org
>
>