Spreadsheet Editor Getting Started

Table of Contents

Introduction

HTML5 Spreadsheet Editor is a web application that can view and edit spreadsheet documents in a web browser. It supports Excel, SpreadsheetML, CSV, OpenDocument and many other formats supported by Microsoft Excel. All basic features, including cell editing, formatting, formula editing, row and column management, etc., are supported.

todo:image_alt_text

HTML5 Spreadsheet Editor uses many features of Aspose.Cells for Java and shows how to use them to create, manipulate, and render a spreadsheet in your Java application.

Features

  • Working with Files
    • Supported Formats
    • Open local files
    • Open from Dropbox
    • Open from URL
    • Create a new Spreadsheet
    • Export to various formats
  • Working with Sheets
    • Add and Remove sheets
    • Rename sheets
    • Switch between sheets
  • Working with Rows and Columns
    • Add a Row
    • Add a Column
    • Remove a Row
    • Remove a Column
    • Column Width and Row Height
  • Working with Cells
    • Selecting a cell
    • Editing a cell
    • Editing Formula
    • Cell alignment
    • Clear Cell
    • Add a cell
    • Remove a cell
  • Working with Text Formatting
    • Bold, italic, underline
    • Font style and size
    • Clear formatting

System Requirements

Software Requirements

Hardware Requirements

The hardware requirements vary based on the Java application server we choose to deploy HTML5 Spreadsheet Editor and the number of spreadsheets we open simultaneously. The following is an estimate, which will help initially set up the environment.

  • 2 GHz CPU
  • 2 GB RAM
  • 500 MB Disk

Download and Installation

HTML5 Spreadsheet Editor is a Java EE application and can be deployed to any Java application server web profile with CDI support. It has been tested with GlassFish.

Source Code

The project source is available at GitHub. We are also maintaining Git mirrors at the following sites:

Use one of the following commands to download the source code via the command line:

GitHub

git clone https://github.com/aspose-cells/Aspose.Cells-for-Java.git

Bitbucket

git clone https://bitbucket.org/asposeshowcase/html5_spreadsheet_editor_by_aspose.cells_for_java.git

Google Code

git clone https://code.google.com/p/html5-spreadsheet-editor/

SourceForge

git clone git://git.code.sf.net/p/html5-spreadsheet-editor/code html5-spreadsheet-editor-code

Build using Maven

The project build process is managed using Maven, so you can prepare a WAR file from the command line without any IDE. Use the following command to generate a WAR for deployment. The documentation of the corresponding application server will help you deploy the generated WAR and its dependencies.

mvn clean install

Using NetBeans

It is very easy to manage the project using NetBeans IDE. NetBeans is one of the popular IDEs among Java developers and is sponsored by Oracle.

  • Download the project source code.
  • Open the project in NetBeans IDE.
  • Click Run button on the toolbar.
  • Select GlassFish server as the Application Server.

Using Eclipse

Eclipse IDE provides official integration to import Maven projects called M2Eclipse:

  1. Install M2Eclipse in your Eclipse IDE. The installation procedure is described on their website.
  2. Download the project source code.
  3. Open the Import dialog from the File menu.
  4. Select Maven Project in the import dialog.
  5. Click Next.
  6. Click Browse to select the location of the source code.
  7. Select pom.xml from the list below.
  8. Click Finish.

The Eclipse IDE should import and load the project.

Support

Bug Report

To send a bug report, create a new issue at the GitHub project page and apply the label bug.

Feature Request

We highly appreciate your feedback and the features you request. To request a new feature or an enhancement to an existing one, please create a new issue at the GitHub project page and apply the label enhancement.

Questions and Help

You can ask all kinds of questions related to HTML5 Spreadsheet Editor using a GitHub issue. Just create a new issue and apply the question label.

Aspose.Cells for Java Forums

Aspose product forums provide full support for both trial and paid customers. Experts are available 24/7 to provide help and answer queries. Visit the product forums here.

Aspose Blogs

Get in touch with us and stay up‑to‑date with the latest news about our products and offers. Subscribe to our blog here.

Contribute

https://github.com/AsposeShowcase/Html5_Spreadsheet_Editor_by_Aspose.Cells_for_Java

Fork me on GitHub

HTML5 Spreadsheet Editor is an open‑source project which allows maximum options for everyone to contribute to the project.

Source Code

The project source is available at GitHub. We are also maintaining Git mirrors at the following sites:

Pull Requests

To contribute source code to the project, just send a pull request via GitHub. Read more information in GitHub’s article on Create a pull request.

License

MIT License

We are using one of the most liberal open‑source licenses to minimize liabilities for contributors. HTML5 Spreadsheet Editor is released under the MIT License.

Aspose License

The product works without an Aspose license, with limitations. To remove limitations, you can acquire a free temporary license or buy a full license.

By default, the editor will try to load Aspose.Total.Java.lic file from the src/main/resources/com/aspose/spreadsheeteditor directory. Just copy the license file to this directory. The default behavior can be changed by editing the AsposeLicense class.

Spreadsheet Editor Developer Guide