Hello- How I can use the example at Eclipse Mars?

dsjung · September 21, 2015, 4:36am

Hello,

It is very urgent issue.

How I can use the example at Eclipse Mars?

Could you detailed explain to me?

Please refer the attached image file.

If I can help with anything else please let me know.

I would be grateful if you could confirm that you will rectify this problem.

Best regards,

Daesung.

babar.raza · September 21, 2015, 9:37am

Hi Daesung,

Thank you for considering Aspose APIs.

You can find the details on how to use Aspose.Cells for Java examples from here. Please note, examples do not include the Aspose.Cells for Java Jar files so you have to download them separately and add their reference in the project.

Regarding the errors, could you please expand the error details in the bottom window and take another snapshot to share it here? The current snapshot does not tell what the error is so we cannot help in resolution.

dsjung · September 22, 2015, 3:19am

Hello,

Please refer the following link.

link : http://wikisend.com/download/462616/error.PNG

Jar file is not exist at Cells for Java latest version.

Please send the 4 jar files.

1.aspose-cells-7.4.2.jar

2.dom4j-1.6.1.jar

3.stax2-api-3.0.2.jar

4.woodstox-core-asl-4.1.1.jar

Also, I can not understand that why created example using old jar file?

If I can help with anything else please let me know.

I would be grateful if you could confirm that you will rectify this problem.

Best regards,

Daesung.

babar.raza · September 22, 2015, 3:32am

Hi Daesung,

Thank you for sharing the snapshot. It shows that the errors are caused due to the missing references to Aspose.Cells for Java API. Please note, the latest revisions of the Aspose.Cells for Java API comprises of only two Jar files as listed below.

aspose-cells-x.x.x.jar
bcprov-jdk16-xxx.jar

Please note, the examples are being updated with every release to add new examples, however, it seems that the project’s configurations are not being updated that is why it is pointing to an old revision of the Aspose.Cells API. In order to get started, please remove all broken reference links from the Java Build Path of the project and re-add (using Add External JARs button) the references of above mentioned Jar files that you have to download from Aspose downloads section.

dsjung · September 22, 2015, 3:32am

Please refer the following contents.

The conversation started at 4:41:14 PM on Sep 22, 2015

[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

babar.raza · September 22, 2015, 6:32am

Hi Daesung,

I have gone through the discussion and I believe that you are facing two main issues as mentioned below.

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.

Please note, the project is set to import the dependencies it self, however, it will download the Aspose.Cells for Java 8.4.2 Jar so you can either update the pom.xml to import the latest build, that is; 8.6.0 or manually reference the previously downloaded Aspose.Cells for Java 8.6.0 Jar in the Class Path.

shakeel.faiz · September 22, 2015, 12:04pm

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.

dsjung · September 23, 2015, 1:05am

Please confirm the WAR.pdf or WAR.docx.

Sample is not normal…

The sample contains too many errors.

I’d appreciate your quick response.

Best Regards,

Daesung

shakeel.faiz · September 23, 2015, 1:18am

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

dsjung · September 23, 2015, 2:12am

Hello,

Please confirm the attached image file. (option.png)

Is this correct?

But, error was still occurs.

Please let me know how to set the JVM option.

Best Regards,

Daesung.

dsjung · September 23, 2015, 9:08pm

Hello,

Please refer the attached image.

I was obedient to what you said.

But, “Number of Name Ranges : 1” message was appears at console.

Is this finished? I have to presentation to our client…

Please send the response as soon as possible.

Best Regards,

Daesung

shakeel.faiz · September 24, 2015, 1:13am

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.

dsjung · September 24, 2015, 1:22am

Hello,

Is there any application(or web application) examples?

Also, please answer for 658033 in reply to 658008.

Best Regards,

Daesung.

shakeel.faiz · September 24, 2015, 2:44am

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”);

dsjung · September 24, 2015, 3:58am

Hello,

My request is not example for one feature.

Once again, I have to presentation for main features of Aspose Cells for Java to our client...

I can not presentation using your sample.

How I can use the war file you sent? What I need are questions answered.

Please answer for 658033 in reply to 658008.

Please confirm the attached image file. (option.png)

Is this correct?

But, error was still occurs.

Please let me know how to set the JVM option.

Don't tell me another way.

I have to running war file at tomcat server without error.

Please let me know how to resolve the error.

Let me know the answer as soon as possible.

Best Regards,

Daesung.

shakeel.faiz · September 24, 2015, 4:57am

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

dsjung · September 24, 2015, 5:13am

So, I had enter the one string.

But, Symptoms are still.

-Djava.awt.headless=true

or

-DAspose.Cells.Disable=SunFontManager

Please re-check your response.

Please let me know how to resolve.

Best Regards

shakeel.faiz · September 24, 2015, 5:22am

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.

shakeel.faiz · September 27, 2015, 8:23pm

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.

shakeel.faiz · September 28, 2015, 11:21pm

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.