Aspose.Cells for Java

Aspose.Cells for Java

Aspose.Cells for Java is an award-winning Excel Spreadsheet Processing API that allows the Java developers to embed the ability to read, write and manipulate Excel spreadsheets in their own Java applications without needing to rely on Microsoft Excel.

Aspose.Cells for Java is a mature, scalable and feature rich API, offering many functions that are way beyond the simple data exporting capabilities of other components available on the market. Aspose.Cells for Java provides the capabilities to export data, format spreadsheets to the most granular level, import & export images, create charts & Pivot Tables, apply & calculate complex formulas, stream Excel data & save the result in various formats.

An overview of Aspose.Cells for Java capabilities.

• Convert Chart to Image

• Convert Worksheet to Image

• Convert Spreadsheet to PDF

• Printing

• Apply Formatting

• Create Charts

• Apply Formulas

• Summarize

• Smart Markers

• Supports JSP Web Application

• Supports Loading Excel Files

• Supports Saving Excel Files

• Porvides Editing Capabilities

• Compatible with Modern Browsers

Advanced Java Excel Spreadsheet API Features

Aspose.Cells for Java includes the following features:

Ability to save & load Excel files to and from streams

Send output to client browser

Load & save ODS format files

Import & export data from Array, ArrayList & Recordset

Import images & charts

Create images & charts through the product API

Import formulas from a designer spreadsheet

Configure page setup

Print spreadsheets to physical printer

Aspose.Cells for Java also supports a number of unique features that developers will only find in Aspose.Cells for Java:

Support for CSV, TSV & HTML formats

Populate worksheets through Smart Markers

Create & manipulate comments

Set auto-filters & page breaks

Set & calculate complex formulas

Create & manipulate conditional formatting rules

Set protection options introduced in Microsoft Excel XP

Create & manipulate named ranges

Create, manipulate & refresh Pivot Tables

Save as HTML files or streams

Create & render sparklines

Create, manipulate & render charts

Formula calculation engine

Export worksheets as SVG files

Read & write large spreadsheets in light-weight mode

Re-sample images in Excel-to-PDF conversion

Trace Precedents & Dependents

Create & manipulate Scenarios

Modify VBA code or Macros in the template file

Save ODS files in ODF 1.1 and 1.2 specifications

Optimize memory usage while working with large files