Displaying Excel Spreadsheet in JSP

Hi,


I have some requirements as follow:
- Displaying Excel file from the backend in JSP page
- The displayed excel spreadsheet needs to be able to calculate the predefined formula from the file
- Need to be able to download the file

I’ve looked around and only found GridWeb, however it seems like that it uses .NET instead of Java.

Can anyone help with this?

Hi,


Thanks for your query.

We have a similar control in JAVA i.e., Aspose.Cells.GridWeb for Java which may suit your requirements. Aspose.Cells.GridWeb (JAVA) is a grid based GUI control that works with a web server (e.g Tomcat) for web applications (JSP/servlets based). Please first download our latest version of Aspose.Cells for Java here:
Once you extract the zipped archive to some folder, you can find the GridWeb’s jar and documentation from the archive sub-folder(s).

For complete details, please see the Aspose.Cells.GridWeb Wiki Conf. Docs:

You may also get the examples of GridWeb from here for your further reference:

Hope, this helps a bit.

Thank you.

Hello, I’ve been playing around with the basic sample app and it is loading.


I’ve managed to load a file from the backend and sent the html body to the jsp. However when i inserted a formula, the javascript console pops up:

Uncaught TypeError: Cannot read property ‘selectNodes’ of null.

was tracing the error, it comes from :

function ajaxcallback() {
if (this.ajaxXmlHttp != null && this.ajaxXmlHttp.readyState == 4) {
if (this.ajaxsendtimeout != null) {
clearTimeout(this.ajaxsendtimeout);
this.ajaxsendtimeout = null
}
var adoc = this.ajaxXmlHttp.responseXML;
var nodes = adoc.selectNodes(“CELLS/CELL”);

I tried watching the network call for ajax and tried the call by itself, it produce this:

java.lang.NullPointerException

at com.aspose.gridweb.zauj.a(Unknown Source)

at com.aspose.gridweb.zauj.a(Unknown Source)

at com.aspose.gridweb.zauj.d(Unknown Source)

at com.aspose.gridweb.MainWeb.k(Unknown Source)

at com.aspose.gridweb.MainWeb.a(Unknown Source)

at com.aspose.gridweb.ExtPage.a(Unknown Source)

at com.aspose.gridweb.ExtPage.a(Unknown Source)

at com.aspose.gridweb.GridWebServlet.doGet(Unknown Source)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

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)

...


Can you please advise what's happening as I don't have access to the source code.

Hi,


Thanks for evaluating Aspose.Cells.GridWeb (JAVA) and details.

We are sorry that you are facing this issue. To evaluate your issue properly on our end, we need your sample project. So, kindly create a simple sample project (.jsp file(s), servlets or other files, etc., you may zip the archive prior attaching here) with all the dependencies/file(s) and Excel file (if you have any) etc., so we could execute your exact code and look into your issue soon.

Thank you.