Java APIs to manipulate Excel spreadsheets

Dynamically Create, Manipulate, Convert, Protect or Print Excel Spreadsheets (including more than 10 file formats) without installing Microsoft Excel.

  Download Free Trial
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.


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 formulae 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, Tab-delimited & HTML formats


Populate worksheets through Smart Markers


Create & manipulate comments


Set auto-filters & page breaks


Set complex formulae


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

Visualize Data with Formatting, Charts & Graphics

Aspose.Cells for Java gives you complete freedom and flexibility to furnish your spreadsheets with all kinds of visual effects. The Java Spreadsheet API allows you to apply formatting to a worksheet, row, column or cell, set fonts with attributes, define cell styling & number formats, add Rich Text and define conditional formatting rules.

Similarly, charts and graphics are visually appealing and can give your spreadsheet a professional look. Aspose.Cells for Java provides a comprehensive set of APIs for creating and manipulating all types of standard and custom chart. Moreover, you may add different types of drawing objects, such as comments, pictures, OLE objects, shapes and controls to the cells.

Efficient, Robust & Reliable Formula Calculation Engine

Aspose.Cells for Java is equipped with a powerful Formula Calculation Engine that supports almost all of the standard and advanced Microsoft Excel formulas and functions. You can read, set and calculate the results of built-in or add-in type, array and R1C1 reference style formulas.

Convert Excel Objects to Image & PDF Formats

Aspose.Cells for Java offers some distinctive features such as converting charts to images & PDF, converting worksheets to images, printing worksheets and converting spreadsheets to PDF file format. The conversion process is greatly flexible thus allowing you to choose a number of options for the conversion, such as re-sampling of images while converting spreadsheets to PDF or controlling the resultant image dimensions when rendering worksheets & charts to images.

Manipulate Rows & Columns

Aspose.Cells for Java allows you to manipulate rows and columns in many different ways. You can easily adjust row height & column width, auto size the width/height of cells according to contents, insert & delete, hide & un-hide as well as group & un-group rows and columns.

Summarize Data with Ease

It can be difficult to get summarized information with very large spreadsheets. A Pivot Table can help you quickly summarize the flat data and to get the desired information according to your needs. Aspose.Cells for Java allows you to create Pivot Tables and Pivot Charts programatically. You can also dynamically change the source data of a Pivot Table and refresh it. Moreover, Aspose.Cells for Java offers Smart Markers which is a great feature to populate worksheets based on some data source and to create visually effective reports.

Visual Control for Spreadsheet Manipulation

Aspose.Cells for Java also provide a UI control which can be be embedded in JSP web applications, and is compatible with all modern web browsers like Chrome, FireFox, Internet Explorer and Opera. End user can use it to load, edit and save Excel files from your web application's front-end.


Support and Learning Resources