Feature Overview

Supported Platforms

Aspose.Cells for Java product covers most of the popular development environments and deployment platforms that support Java.

FeatureDescription
JavaAspose.Cells for Java is available for 1.6, 1.7 and 1.8 and will run in any place where Java is installed.
File Formats and Conversions

Many customers worldwide rely on the thorough document import and export features provided by Aspose.Cells for Java.

FeatureDescriptionAspose.Cells for Java
High-Quality ConversionsQuickly and reliably, convert between several popular document formats.Yes
Microsoft Excel Workbook (XLS)The fastest and most complete XLS format implementation you can find.Yes
SpreadsheetML (XLSX, XML)Aspose.Cells supports OOXML, Flat OPC and also Excel 2003 XML. Moreover,
the component supports all major Excel 2007, 2010 and 2013 file formats e.g XLSX, XLTX, XLSM, XLTM etc.
Yes
Comma Separated Value (CSV)Comprehensive support of the CSV format to interact with a variety of applications.Yes
HTMLSave as HTML is available.Yes
OpenDocument (ODS)Aspose.Cells can load and save documents in the OpenDocument Spreadsheet (.ods) format.Yes
Adobe Portable Document Format (PDF)Convert any Spreadsheet to PDF with high fidelity.Yes
Tab DelimitedLoad and save documents in the tab delimited file format.Yes
Plain Text (TXT)Easily extract text by saving in plain text format.Yes
Rendering and Printing

Aspose.Cells for Java now provides high fidelity rendering of spreadsheet pages.

FeatureAspose.Cells for Java
Layout document into pages with high fidelity to Microsoft Excel® (exactly like Microsoft Excel® would do that).Yes
Render worksheet pages to raster images (PNG, JPEG, BMP etc.).Yes
Render spreadsheet pages to vector images (EMF).Yes
Specify image resolution, quality, compression and other options.Yes
Print spreadsheets using the .NET printing infrastructure. The component has built-in print method to print
worksheets as shown in Microsoft Excel’s print preview.
Yes
Update page numbers and other fields before rendering or printing.Yes
Spreadsheet Content Features

Aspose.Cells for Java provides a rich object model that consists of over 100 public classes/interfaces, which allow you to programmatically generate, combine, modify, parse or otherwise examine loaded spreadsheets. Some key features are given in the below table.

FeatureAspose.Cells for Java
Import/export data from an Array, ArrayList, ResultSet etc.Yes
Add a copy of existing worksheet (all contents including images, charts, other objects etc.)Yes
Copy or move worksheets within or between workbooksYes
Insert imagesYes
Create chartsYes
Set gradient background for charts using APIYes
Add comments to cellsYes
Microsoft Excel 2007 themes and colorsYes
Create auto-filtersYes
Implement data validationsYes
Implement data sortingYes
Find and replace textYes
Merge/split CellsYes
Group/ungroup rows and columnsYes
Create custom page breaksYes
Insert/delete or hide rows, columns and sheetsYes
Calculate complex Excel formulaeYes
Support advanced conditional formatting supported in Microsoft Excel 2007Yes
Freeze/unfreeze PanesYes
Insert hyperlinks to link dataYes
Implement Smart MarkersYes
Specify document properties settingsYes
Protect/unprotect worksheetsYes
Specify advanced protection options introduced in Excel XP and later versionsYes
Create list object/Microsoft Excel tablesYes
Create subtotalsYes
Insert form controls and other drawing shapes/objectsYes
Create pivot tables and pivot chartsYes
Preserve or remove addin, VBA, macrosYes
Manipulate named rangesYes
Create custom chartsYes
Add, preserve or extract OLE objects from the spreadsheets.Yes
Implement Microsoft Excel 2010 sparklinesYes
Encrypt filesYes
Spreadsheet Formatting Features

Aspose.Cells for Java provides detailed programmatic access to formatting properties of all spreadsheet elements.

FeatureAspose.Cells for Java
Apply all characters formatting in the cells including fonts, colors, effects, borders and shading.Yes
Apply all the number format settings (supported in Microsoft Excel) for the cells.Yes
Set all types of text alignment settings.Yes
Apply different kinds of Font Settings for the cells.Yes
Apply different colors to cells, fonts, gridlines, graphic objects etc.Yes
Apply different rich text formatting in a single cell.Yes
Apply different border settings on cells.Yes
Apply different background patterns on cells.Yes
Apply Format settings on a worksheet, row, column or a range of cells etc.Yes
PageSetup Features

You can use Aspose.Cells for Java to implement page setup options for worksheets.

FeatureAspose.Cells for Java
Adjust your page orientation, scaling, paper size.Yes
Specify your margins and page centering.Yes
Create or edit your header and/or footer.Yes
Set print area, print titles, or turn on gridlines etc.Yes