We have an internal web site where we create lots of web reports. I tested using Apose.Cells for exporting the reports and it works great.
I showed it to my boss with questions about purchasing it and he asked whether this could be used for the data in the web page. I couldn't see any examples where the Excel spreadsheet was imbedded in the web page. We are have some old pages using sortabletable.js (yuck) and have started experimenting with DataTables, which looks pretty good.
If we could use excel in the pages, that would be the best.
Please let me know if this can be done and where some example code can be found.
1) Well, Aspose.Cells is just a class library that does not provide any UI. I think you may try to convert the Excel sheets/ charts to image files or utilize other utilities via Aspose.Cells APIs and then paste that image(s) on your web pages if it suits your needs, see the documents in the section for your reference:
2) Alternatively, I think you may use our Aspose.Cells.GridWeb control - A grid control that is specifically designed to work on web environments/projects. It is an independent control where you may load Excel files into its grid matrix, create/design worksheets and update/ manipulate the data into the cells in WYSIWYG (visual) manner. It supports all the important features if not everything though. It also supports to read/write and calculate formulas too. It can load and save/re-save the files to Excel files on the fly. See the documents / articles for your reference:
Note: it does not support to create charts and also does not support to render charts (from the template Excel files) as chart objects, rather the chart objects are imported to GridWeb as images.
Thanks for pointing me in the direction of GridWeb.
I have been trying to run the demo's but am running into problems. The first demo "Creating Content" loads a page with an empty spreadsheet, but when I click on the button to "Create Content" I run into an error. The complete error message is below.
By debugging I see that the problem is with the prepareRender();
[9/17/14 16:38:38:097 EDT] 0000003b servlet E com.ibm.ws.webcontainer.servlet.ServletWrapper service SRVE0068E: An exception was thrown by one of the service methods of the servlet [FunctionServlet] in application [gridwebdemo1EAR]. Exception created : [java.lang.NullPointerException at com.ibm.ws.webcontainer.srt.SRTServletRequest$SRTServletRequestHelper.access$1700(SRTServletRequest.java:3141) at com.ibm.ws.webcontainer.srt.SRTServletRequest.parseParameters(SRTServletRequest.java:2197) at com.ibm.ws.webcontainer.srt.SRTServletRequest.getParameter(SRTServletRequest.java:1822) at com.aspose.gridweb.GridWebBean.a(Unknown Source) at com.aspose.gridweb.GridWebBean.prepareRender(Unknown Source) at com.aspose.gridweb.test.TestGridWebBaseServlet.doPost(TestGridWebBaseServlet.java:56) at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1224) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:774) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:456) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1032) at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:895) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1690) ] [9/17/14 16:38:38:097 EDT] 0000003b LocalTranCoor E WLTC0017E: Resources rolled back due to setRollbackOnly() being called. [9/17/14 16:38:38:097 EDT] 0000003b webapp E com.ibm.ws.webcontainer.webapp.WebApp logServletError SRVE0293E: [Servlet Error]-[FunctionServlet]: java.lang.NullPointerException at com.ibm.ws.webcontainer.srt.SRTServletRequest$SRTServletRequestHelper.access$1700(SRTServletRequest.java:3141) at com.ibm.ws.webcontainer.srt.SRTServletRequest.parseParameters(SRTServletRequest.java:2197) at com.ibm.ws.webcontainer.srt.SRTServletRequest.getParameter(SRTServletRequest.java:1822) at com.aspose.gridweb.GridWebBean.a(Unknown Source) at com.aspose.gridweb.GridWebBean.prepareRender(Unknown Source) at com.aspose.gridweb.test.TestGridWebBaseServlet.doPost(TestGridWebBaseServlet.java:56) at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1224) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:774) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:456) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1032) at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:895) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1690)
[9/17/14 16:38:38:066 EDT] 0000003b SystemErr R java.lang.NullPointerException [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.srt.SRTServletRequest$SRTServletRequestHelper.access$1700(SRTServletRequest.java:3141) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.srt.SRTServletRequest.parseParameters(SRTServletRequest.java:2197) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.srt.SRTServletRequest.getParameter(SRTServletRequest.java:1822) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.aspose.gridweb.akg.a(Unknown Source) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.aspose.gridweb.akg.e(Unknown Source) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.aspose.gridweb.MainWeb.h(Unknown Source) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.aspose.gridweb.MainWeb.a(Unknown Source) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.aspose.gridweb.GridWebBean.a(Unknown Source) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.aspose.gridweb.GridWebBean.prepareRender(Unknown Source) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.aspose.gridweb.test.TestGridWebBaseServlet.doPost(TestGridWebBaseServlet.java:56) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1224) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:774) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:456) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1032) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:895) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) [9/17/14 16:38:38:097 EDT] 0000003b SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) [9/17/14 16:38:38:097 EDT] 0000003b SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1690)[9/17/14 16:38:38:097 EDT] 0000003b servlet E com.ibm.ws.webcontainer.servlet.ServletWrapper service SRVE0068E: An exception was thrown by one of the service methods of the servlet [FunctionServlet] in application [gridwebdemo1EAR]. Exception created : [java.lang.NullPointerException at com.ibm.ws.webcontainer.srt.SRTServletRequest$SRTServletRequestHelper.access$1700(SRTServletRequest.java:3141) at com.ibm.ws.webcontainer.srt.SRTServletRequest.parseParameters(SRTServletRequest.java:2197) at com.ibm.ws.webcontainer.srt.SRTServletRequest.getParameter(SRTServletRequest.java:1822) at com.aspose.gridweb.GridWebBean.a(Unknown Source) at com.aspose.gridweb.GridWebBean.prepareRender(Unknown Source) at com.aspose.gridweb.test.TestGridWebBaseServlet.doPost(TestGridWebBaseServlet.java:56) at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1224) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:774) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:456) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1032) at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:895) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1690) ] [9/17/14 16:38:38:097 EDT] 0000003b LocalTranCoor E WLTC0017E: Resources rolled back due to setRollbackOnly() being called. [9/17/14 16:38:38:097 EDT] 0000003b webapp E com.ibm.ws.webcontainer.webapp.WebApp logServletError SRVE0293E: [Servlet Error]-[FunctionServlet]: java.lang.NullPointerException at com.ibm.ws.webcontainer.srt.SRTServletRequest$SRTServletRequestHelper.access$1700(SRTServletRequest.java:3141) at com.ibm.ws.webcontainer.srt.SRTServletRequest.parseParameters(SRTServletRequest.java:2197) at com.ibm.ws.webcontainer.srt.SRTServletRequest.getParameter(SRTServletRequest.java:1822) at com.aspose.gridweb.GridWebBean.a(Unknown Source) at com.aspose.gridweb.GridWebBean.prepareRender(Unknown Source) at com.aspose.gridweb.test.TestGridWebBaseServlet.doPost(TestGridWebBaseServlet.java:56) at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1224) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:774) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:456) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1032) at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:895) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1690)
[9/17/14 16:38:38:066 EDT] 0000003b SystemErr R java.lang.NullPointerException [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.srt.SRTServletRequest$SRTServletRequestHelper.access$1700(SRTServletRequest.java:3141) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.srt.SRTServletRequest.parseParameters(SRTServletRequest.java:2197) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.srt.SRTServletRequest.getParameter(SRTServletRequest.java:1822) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.aspose.gridweb.akg.a(Unknown Source) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.aspose.gridweb.akg.e(Unknown Source) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.aspose.gridweb.MainWeb.h(Unknown Source) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.aspose.gridweb.MainWeb.a(Unknown Source) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.aspose.gridweb.GridWebBean.a(Unknown Source) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.aspose.gridweb.GridWebBean.prepareRender(Unknown Source) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.aspose.gridweb.test.TestGridWebBaseServlet.doPost(TestGridWebBaseServlet.java:56) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1224) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:774) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:456) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1032) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:895) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452) [9/17/14 16:38:38:066 EDT] 0000003b SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) [9/17/14 16:38:38:082 EDT] 0000003b SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) [9/17/14 16:38:38:097 EDT] 0000003b SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) [9/17/14 16:38:38:097 EDT] 0000003b SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1690)
As you are using Aspose.Cells.GridWeb for JAVA component, please see the document/ article on how to use and run featured demos. I have tested to deploy and run the demos on web server, it works fine:
Your directions are for a tomcat server. We are using Websphere. I used Relational Architect to import the war file into a new project. Some of the features work and some of them don't. Since this is the environment we have I was hoping to get some help getting this to work.
I just wanted to let you know that I did some more experimenting with the gridwebdemo and I found the same error on more than just the Creating Contents page.
When I go to the Enable Editing page and click on the checkbox "Enable Editing", on the Worksheets page when I click any of the buttons except Reload, on the Cells page all the buttons except Reload I get the exact same error:
[9/18/14 15:41:04:825 EDT] 0000008b SystemOut O control.get_UniqueID():mycomponent [9/18/14 15:41:06:635 EDT] 0000008b servlet E com.ibm.ws.webcontainer.servlet.ServletWrapper service SRVE0068E: An exception was thrown by one of the service methods of the servlet [WebCellsServlet] in application [gridwebdemo1EAR]. Exception created : [java.lang.NullPointerException at com.ibm.ws.webcontainer.srt.SRTServletRequest$SRTServletRequestHelper.access$1700(SRTServletRequest.java:3141) at com.ibm.ws.webcontainer.srt.SRTServletRequest.parseParameters(SRTServletRequest.java:2197) at com.ibm.ws.webcontainer.srt.SRTServletRequest.getParameter(SRTServletRequest.java:1822) at com.aspose.gridweb.GridWebBean.a(Unknown Source) at com.aspose.gridweb.GridWebBean.prepareRender(Unknown Source) at com.aspose.gridweb.test.TestGridWebBaseServlet.doPost(TestGridWebBaseServlet.java:56)[9/18/14 15:41:04:825 EDT] 0000008b
Some of the other pages like HeaderBar & CommandButton work just fine.
I was wondering if maybe I am missing a jar file or something. I have brought in everything I could think to find. Aspose-cells.8.2.0.jar, aspose-gridweb-8.1.1.jar, bcprov-djk15-146.jar, commons-lang3-3.3.2.jar, jsch-0.0.27.jar, org.eclipse.jgit-2.2.0.201212191850-r.jar.
Brita
Remember I am on WebSphere and Rational Architect.
How do we stand on this ticket? I understand if it is taking longer, but I would like a response to know that you are working on it.
I have giving the Aspose information to purchasing, but if I can't get the application to add data to a spreadsheet on a web page we may have to keep looking.
Thanks,
Brita
ps. in order to get the test file to open up I had to make a change to line 103 on the base servlet to: gridweb.ImportExcelFile(path + "//file//data.xlsx");
Note the // before file in order to get to the data. Could this path change be causing the problem with GridWebBean.a ?
Thanks for your posting and using Aspose.Cells for GridWeb.
We found some of the demos are not working while some are working fine. It will take some time for development team to fix these demos. Meanwhile, could you please get some idea from those demos which are running fine and start using the Aspose.Cells for GridWeb (Java) at your end. Thanks for your understanding.
It has been a couple of weeks now, I was wondering how you are coming on the fixes. I don't need all of them just now. I mostly need the first one, where you can click the button to populate the data on the web page.
We have checked the Create Contents demo which is the first demo and found it is working fine. I have attached the Word document with screenshots showing its running.
Could you please let us know what issue you are facing with this demo? So that we could request development team to investigate and fix the issue.
Hi Shakeel, I have spent quite a bit of time trying to track this down. Do you want me to break this apart into 3 tickets to make this easier to process?
1. There is an issue with IE 10 (not in compatibility mode). I believe that this is an issue with the version of JQuery that you are running. Examples of the errors are shown below.
2. There is a null pointer exception being thrown in line 57 of TestGridWebBaseServlet - gridweb.prepareRender(). The stack trace indicates that it originates at the method gridweb.GridWebBean.a
3. In Firefox or IE8, there is still the null pointer exception, but the data will load. BUT, you don’t see any changes after clicking the create button. You have to click either “Sheet 5” or “Evaluation Copyright Warning” for the “invoice” tab to appear.
I will be happy to attach screen shots if you would like. I wasn’t able to see your attachments.
Brita
SCRIPT5007: Unable to get property ‘appendChild’ of undefined or null reference acwmain.js, line 73 character 231 SCRIPT257: Could not complete the operation due to error 80020101. jquery-1.7.2.min.js, line 2 character 11336 XML5633: End-tag name does not match the corresponding start-tag name. , line 7 character 7
Thanks for your posting and considering Aspose.Cells.
The screenshots are present in the attached Create Contents Demo.docx file. Yes, it will be better, if you could provide screenshots with error description. We will create required tickets in our database for development team to investigate and fix these issues.
Thanks for providing us the errors description word document and considering Aspose.Cells for GridWeb Java.
We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as
CELLSJAVA-41033 - Fix the errors in - Creating Contents - GridWeb Demo.
For (Loading box doesn’t close after saving file) issue, it is just same design as in GridWeb .NET version.once user click on the loading box, it will close.
We have fixed the other issues now and will send a new fix version on Monday, 20-Oct-2014.
We will update the Demo Project also.
Once, the fix is available for you, we will let you know asap by posting in this thread.
We have fixed the issue “CELLSJAVA-41033”. Also refer to the featured demos in the archive and deploy the demos (that are updated in the attached zipped archive) on the server to evaluate the component for different features on your end.
Thanks for the fixes. I am very happy and have submitted a purchase request to our procurement department. Unfortunately they are awfully slow. Hopefully you will receive it by the end of the year, and we can start using it in our reports.