Hello,
Hi Daesung,
Hi Daesung,
- aspose-cells-x.x.x.jar
- bcprov-jdk16-xxx.jar
Please refer the following contents.
[4:41 PM] Tahir Manzoor: Hi there
[4:41 PM] Tahir Manzoor: How may I help you?
[4:41 PM] dsjung: Hello,
[4:41 PM] dsjung: I’m Daesung.
[4:41 PM] dsjung: Our client had request that product(Cells for Java) feature and example rehearsal to our company(Tangunsoft). Our client’s development environment is web application used jsp.
[4:43 PM] dsjung: Can I use the product(Cells for Java) at jsp?
[4:43 PM] Tahir Manzoor: Yes
[4:43 PM] Tahir Manzoor: You can use Aspose.Cells for Java where Java is installed
[4:49 PM] dsjung: Could you send the sample??
[4:49 PM] Tahir Manzoor: ok
[4:49 PM] dsjung: I can not find jsp sample.
[4:50 PM] Tahir Manzoor: Could you please share your requirements?
[4:50 PM] dsjung: yes
[4:50 PM] Tahir Manzoor: You can use Java code in Jsp
[4:50 PM] dsjung: yes.
[4:50 PM] dsjung: Also use the tomcat web server.
[4:51 PM] dsjung: I had download the sample from following url.
[4:52 PM] dsjung: URL : GitHub - aspose-cells/Aspose.Cells-for-Java: Aspose.Cells for Java examples, plugins and showcases
[4:52 PM] dsjung: But, This is not jsp sample. This is java sample.
[4:52 PM] dsjung: I would like to sample(jsp) that include jar files.
[4:52 PM] dsjung: I would like to find the sample(jsp) that include jar files.
[4:53 PM] Tahir Manzoor: There is no Jsp examples
[4:53 PM] dsjung: Where is the jsp examples?
[4:53 PM] dsjung: Could you send the jsp examples?
[4:53 PM] Tahir Manzoor: However, you can use Java code example to check Aspose.Cells APIs
[4:54 PM] Tahir Manzoor: Could you please share what you want to achieve using Aspose.Cells? We will then guide you accordingly.
[4:55 PM] dsjung: Please refer the following URL.
[4:55 PM] dsjung: http://www.aspose.com/java/excel-component/key-features.aspx
[4:56 PM] dsjung: Our client would like to confirm the features of url from jsp.
[4:58 PM] Tahir Manzoor: Yes
[4:58 PM] Tahir Manzoor: I think, you are mixing jsp and Java
[4:58 PM] Tahir Manzoor: In Jsp web application, you use Java code
[4:59 PM] Tahir Manzoor: Please note that Aspose.Cells for Java is a class library. You can use it where Java is installed.
[4:59 PM] dsjung: Yes, I know…
[4:59 PM] dsjung: But
[5:00 PM] dsjung: It takes too much time for created example of url features.
[5:01 PM] Tahir Manzoor: Please download the examples from here:
[5:01 PM] Tahir Manzoor:https://github.com/asposecells/Aspose_Cells_Java/tree/master/Examples
[5:01 PM] Tahir Manzoor: and use the appropriate example in your jsp application
[5:01 PM] Tahir Manzoor: You just need to call the example methods shared in above github link
[5:02 PM] dsjung: I had tried the running example.
[5:02 PM] dsjung: But, following error was occurs.
[5:03 PM] Tahir Manzoor: Let me post your query in Aspose.Cells forum
[5:03 PM] Tahir Manzoor: They will reply you according to your requirements.
[5:03 PM] dsjung: But,
[5:04 PM] dsjung: Error was occurs…Hold on a minute, please.
[5:05 PM] dsjung: You can used the download error screen using following link
[5:05 PM] dsjung: link : http://wikisend.com/download/462616/error.PNG
[5:07 PM] dsjung: I had found the user that have same error at forum.
[5:07 PM] dsjung: same error forum : Need Jar File
[5:29 PM] Tahir Manzoor: thanks for sharing the detail in forum thread
Hi Daesung,
- JSP Examples: I am afraid, we currently do not have JSP examples built for latest releases. We can surely consider this requirement for future as it will take time to create new examples.
- Problems with Existing Examples: Please follow the below instructions to get the examples working on your side.
- Either download the example archive fresh from the Github or manually remove the following two files from \Aspose_Cells_Java-master\Examples</b> path after extracting the downloaded archive.
- .classpath
- .project
- In Eclipse interface, click File > Import.
- On Import dialog, type or select Existing Maven Project.
- On Import Maven Project dialog, browse to the root \Aspose_Cells_Java-master\Examples path and select the project (pom.xml) from the list of available projects.
- Click Finish.
- To run an example, just right click on the file and choose Run As - Java Application, the example will be executed and the output will be shown in the built in console output window.
Hi,
Thanks for using Aspose.Cells.
As mentioned by Babar earlier, we do not have JSP samples relating to Aspose.Cells available for recent versions. However, JSP samples for older versions like v7.0.1 are available.
Please download the attached Aspose.Cells Web (JSP) Demos file. It contains Demos.war file. Please deploy it in your Tomcat in Webapps directory and demos will start running. You can also see their sample code in the zip archive.
Please confirm the WAR.pdf or WAR.docx.
Hi,
Thanks for your posting and using Aspose.Cells.
For this issue, please try following JVM option when starting the java application:
-Djava.awt.headless=true
or
-DAspose.Cells.Disable=SunFontManager
Hello,
Hello,
Hi Daesung,
Thanks for your posting and considering Aspose.Cells.
I have checked your image and found that you were able to run the example successfully. The console output you have shown inside your image is actually the output of the example you have run which means your issue is fixed now.
Hello,
Hi Daesung,
Thanks for your posting and considering Aspose.Cells.
Please try running the examples in some other machine. You can create a virtual machine using Oracle Virtual Box and run the examples there and it should be running because this issue might be related to your system environment.
Also, you do not need to rely on JSP because Aspose.Cells does not depend on JSP. If you can create a simple JSP page yourself, you can use Aspose.Cells inside it yourself.
For example the following code creates a workbook with “hello aspose” in cell A1. Just create your own JSP page and use this code and you should have a running example.
I have also attached the output excel file generated by the code for a reference. You need to use the latest version to run this code.
Java
//Create workbook
Workbook workbook = new Workbook();
//Access first workshet
Worksheet worksheet = workbook.getWorksheets().get(0);
//Access cell A1
Cell cell = worksheet.getCells().get(“A1”);
//Put some string inside it
cell.putValue(“Hello Aspose!”);
//Save workbook on a disk
workbook.save(“output.xlsx”);
Hi,
Thanks for your posting and using Aspose.Cells.
Please use only one of the option, don’t use both and then see how it goes.
-Djava.awt.headless=true
or
-DAspose.Cells.Disable=SunFontManager
So, I had enter the one string.
or
-DAspose.Cells.Disable=SunFontManager
Hi,
Thanks for your posting and considering Aspose.Cells.
Please spare us some time. I will have to prepare an environment and then I will share screenshots with you. I will test it on fresh Windows 7 - 64 bits with Java 1.7 or 1.8 and latest Tomcat version and then update you.
Hi,
Thanks for considering Aspose.Cells.
I have tried JSP aspose.cells demos on fresh Windows 7 - 64 bit, JDK 1.8 and Tomcat 7 & 8 and was able to generate the same exception as you have shown. This exception supposed to be fixed by the instructions I have given in the above posts. Because we have suggested this solution to many and it worked for them. But unfortunately this did not solve the issue. I tried setting JVM options through interface as you have shown or inside catalina.bat but neither worked.
However, the same demos used to work on my previous machines. So I will now try older JDK and older Tomcat versions and update you with a feedback.
Hi,
Thanks for using Aspose.Cells.
I have now successfully ran the JSP demos examples on
- JDK 1.6 (jdk-6u45-windows-x64.exe)
- Tomcat 7.0
I have attached the screenshot for your reference. Please run the demos as per above environment and you should then be able to run the demos successfully.