Dashboard issues

Aspose.Cells Product Family
1

Downloaded. Extracted and ran .bat for Aspose.Cells dashboard and this is what I get. Do have internet connect but application needs to go through a proxy - how can I configure? Not a great start for evaluating software, Jexcel was much easier to get running for demo purposes.


C:\Users\mdshipm\Downloads\Aspose.Examples.Dashboard.Java>Start.bat
Trying to find JRE 1.7 in Program Files…
Found JRE in C:\Program Files\Java\jre7
Updating Aspose Examples Dashboard Application…
java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.(Unknown Source)
at sun.net.www.http.HttpClient.New(Unknown Source)
at sun.net.www.http.HttpClient.New(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown
Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Sour
ce)
at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown So
urce)
at java.net.URLConnection.getContent(Unknown Source)
at aspose.examplescenter.gitutil.GitHelper.isInternetReachable(GitHelper
.java:65)
at aspose.examplescenter.gitutil.GitHelper.updateRepository(GitHelper.ja
va:83)
at aspose.examplescenter.gitutil.GitHelper.updateAppRepository(GitHelper
.java:148)
at aspose.examplescenter.gitutil.GitHelper.updateAllRepositories(GitHelp
er.java:51)
at aspose.examples.launcher.AsposeExamplesLauncher.updateDashboardApp(As
poseExamplesLauncher.java:26)
at aspose.examples.launcher.AsposeExamplesLauncher.main(AsposeExamplesLa
uncher.java:17)
Could not update the Dashboard application. Reason: No internet connection avail
able, please try again later.
‘Startapp.bat’ is not recognized as an internal or external command,
operable program or batch file.
Finished Launcher Batch file execution

2

Hi,


I am afraid, there is no better way to cope with it as Example dashboard does require internet to download and update the demos/examples for the Dashboard. Anyways, I have attached the zipped archive containing the source files/ JAVA Programs of the featured demos for your reference here.

Moreover, we recommend you to kindly browse Aspose.Cells for Java Wiki Conf. Docs for your reference:
https://docs.aspose.com/display/cellsjava/Home



Thank you.

3

As stated I DO have internet, can you tell me how to make dashboard work with a proxy?

4

Hi Marie,


We are sorry for the inconvenience caused to you.

It seems you are behind a restrictive firewall which is blocking the Examples Dashboard script from downloading required resources from Github and other repositories.

Anyway, we will shortly upload a self contained package of Aspose.Cells for Java examples on the Dropbox that will not require internet connectivity to execute the examples on your end. The package contains everything that is required, however, the console may show similar errors as shared in your original post but you may ignore them. Once Example Dashboard appears, please select the node “Aspose.Cells” from the left hand pane, and start exploring the examples.
5

Hi Marie,


Thank you for your patience with us.

Please download the offline Examples Dashboard containing all the demos of Aspose.Cells for Java only. Please extract the archive on the root of any local drive and run the start.bat. The console may show you some errors because it will try to get the latest resources, however, you may ignore these errors.

Please feel free to write back in case you face any difficulty.

6

Thank you for providing this file; I was hoping in your dashboard examples to find an application that showed how to open and display an excel file. Can this be accomplished?

Thanks,

Marie

7

Hi Marie,


Thank you for writing back.

Previously provided archive contains many examples on loading existing spreadsheets and perform different operation on it, such as data styling, conversion to other spreadsheet formats, conversion to PDF & raster image formats and much more.

Please elaborate how do you wish to display the Excel spreadsheets, and we will guide you accordingly.
8

I need a way to embed an excel file into a gui java application. The embedded excel file needs to retain all functionality currently associated with excel. So users can open up java application load their excel file and then proceed as normal running their macros and interacting with that excel file as they would as if it wasn’t embedded in a java application.

9

Hi Marie,

Thank you for elaborating your requirements.

The previously provided archive contains the examples of Aspose.Cells for Java API that is a back-end library to create, manipulate & convert spreadsheets without a visual component. You can use the Aspose.Cells for Java API to create an application that could simulate the MS Excel interface. You may also consider using GridWeb; a web based visual component that allows to load an existing or new spreadsheet in a web application for the users to perform some basic operations such as manipulate data, re-calculate formulas, saving the spreadsheets and more. Unfortunately, both components (Aspose.Cells for Java & Aspose.Cells.GridWeb for Java) do not offer any means to create, manipulate or execute the macros in a given spreadsheet. We already have the aforesaid feature on our road map but we may not be able to provide it some time soon.