Aspose.Cells Java for Apache POI SS - HSSF and XSSF

Introduction

Apache POI SS - HSSF and XSSF

HSSF is the POI Project’s pure Java implementation of the Excel ‘97(-2007) file format. XSSF is the POI Project’s pure Java implementation of the Excel 2007 OOXML (.xlsx) file format.

HSSF and XSSF provides ways to read spreadsheets create, modify, read and write XLS spreadsheets. They provide:

  • low level structures for those with special needs
  • an eventmodel api for efficient read-only access
  • a full usermodel api for creating, reading and modifying XLS files

Read more at poi.apache.org

Aspose.Cells for Java

Aspose.Cells for Java is an award-winning Excel Spreadsheet component that allows Java developers to embed the ability to read, write and manipulate Excel® spreadsheets (XLS, XLSX, XLSM, XLSB, XLTX, SpreadsheetML, CSV, ODS), HTML, MHTML, PDF and image file formats into their own Java applications without needing to rely on Microsoft Excel®.

Aspose.Cells for Java is a mature, scalable and feature rich component that offers many functions that are way beyond the simple data exporting capabilities of other vendors. With Aspose.Cells for Java developers can export data, format spreadsheets to the most granular level, import images, create charts, apply and calculate complex formulas, stream Excel® data, save in various formats and much more - all this without the need of Microsoft Excel® or Microsoft Office Automation.

Read more at aspose.com

Aspose.Cells Java for Apache POI SS - HSSF and XSSF

Project Aspose.Cells for Apache POI HSSF and XSSF shows how different tasks can be performed using Aspose.Cells Java APIs in comparison with Apache POI SS. The project also covers the features that are only available in Aspose.Cells APIs but not in Apache POI SS for dealing with spreadsheets.

This project is helpful for developers who want to compare Apache POI HSSF and XSSF with Aspose.Cells OR migrate from Apache POI SS to Aspose.Cells.

System Requirements and Supported Platforms

System Requirements

Following are the system requirements to execute Aspose.Cells Java for Apache POI SS - HSSF and XSSF:

  • Java 1.4 or above installed.
  • Downloaded Aspose.Cells component.
  • Downloaded Apache POI SS libraries.

Supported Platforms

Following are the supported platforms:

  • Apache POI 3.11 and above.
  • Aspose.Cells 7.7.2 and above.
  • Java IDE (Eclipse, NetBeans, IntelliJ, …).

Downloading

You can directly include the source code of Aspose.Cells Java for Apache POI SS in your own project, Following releases of running examples are available to download on all of the below mentioned social coding sites:

CodePlex


GitHub

To configure Aspose.Cells for Java API, include the Aspose repository URL and Aspose.Cells for Java API maven dependency in your pom.xml as following:

Aspose Maven Repository

 <repositories>

    <repository>

        <id>aspose-maven-repository</id>

        <name>Aspose Maven Repository</name>

        <url>http://repository.aspose.com/repo/</url>

    </repository>

</repositories>

Aspose.Cells for Java Maven Dependency

 <dependencies>

    <dependency>

        <groupId>com.aspose</groupId>

        <artifactId>aspose-cells</artifactId>

        <version>8.6.0</version>

    </dependency>

</dependencies>

Support, Extend and Contribute

Support

From the very first days of Aspose, we knew that just giving our customers good products would not be enough. We also needed to deliver good service. We are developers ourselves and understand how frustrating it is when a technical issue or a quirk in the software stops you from doing what you need to do. We’re here to solve problems, not create them.

This is why we offer free support. Anyone who uses our product, whether they have bought them or are using an evaluation, deserves our full attention and respect.

You can log any issues or suggestions related to Aspose.Cells Java for Apache POI SS - HSSF and XSSF using any of the following platforms:

Extend and Contribute

Aspose.Cells Java for Apache POI (HSSF+XSSF) is open source and its source code is available on the major social coding websites listed below. Developers are encouraged to download the source code and contribute by suggesting or adding new feature or improving the existing ones, so that others could also benefit from it.

Source Code

You can get the latest source code from one of the following locations

How to configure the source code

Please follow these simple steps in order to open and extend the source code while using:

Eclipse IDE

  1. Download/Clone the source code.
  2. Open Eclipse and Choose File > Import…
  3. Select General > Existing Projects into Workspace.
  4. Browse to select root directory of the latest source code that you have downloaded.
  5. Click Finish to successfully import the downloaded project.

NetBeans IDE

  1. Download/Clone the source code.
  2. Open NetBeans and Choose File > New Project…
  3. In Choose Project tab: Select Java > Java Project with Existing Sources.
  4. In Name and Location tab: Provide your desired Project Name and Project Folder.
  5. In Existing Sources tab: Click Add Folder… and browse to select root directory of the latest source code that you have downloaded.
  6. Click Finish to successfully create the downloaded project.

Sample Code Examples

This section includes the following topics