Features

Aspose.Cells for PHP via Java Features Overview

This section provides a comparison of the availability of features between Aspose.Cells for Java and Aspose.Cells for PHP via Java.

File Formats and Conversions

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

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

Rendering and Printing

Aspose.Cells now provides high‑fidelity rendering of spreadsheet pages.

Feature	Aspose.Cells for Java	Aspose.Cells for PHP via Java
Lay out the document into pages with high fidelity to Microsoft Excel® (exactly as Microsoft Excel® would do).
Render worksheet pages to raster images (PNG, JPEG, etc.).
Render worksheet pages to raster images (Multipage TIFF, GIF).
Render spreadsheet pages to vector images (EMF).
Specify image resolution, quality, compression and other options.
Print spreadsheet pages using the Java printing infrastructure.
Update page numbers and other fields before rendering or printing.

Spreadsheet Content Features

Aspose.Cells 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 listed in the table below.

Feature	Aspose.Cells for Java	Aspose.Cells for PHP via Java
Import/export data from an array, ArrayList, ResultSet, etc.
Add a copy of existing worksheet (all contents including images, charts, other objects etc.)
Copy or move worksheets within or between workbooks
Insert images
Create charts
Set gradient background for charts using API
Add comments to cells
Microsoft Excel 2007 and later themes and colors
Create auto-filters
Implement data validations
Implement data sorting
Find and replace text
Merge/split cells
Group/ungroup rows and columns
Create custom page breaks
Insert/delete or hide rows, columns and sheets
Calculate complex Excel formulae
Support advanced conditional formatting available in Microsoft Excel 2007 and later
Freeze/unfreeze panes
Insert hyperlinks to link data
Implement Smart Markers
Specify document property settings
Protect/unprotect worksheets
Specify advanced protection options introduced in Excel XP and later versions
Create list objects/Microsoft Excel tables
Create subtotals
Insert form controls and other drawing shapes/objects
Create pivot tables and pivot charts
Preserve or remove add‑ins, VBA, macros
Manipulate named ranges
Create custom charts
Add, preserve or extract OLE objects from the spreadsheets.
Implement sparklines
Encrypt files

Spreadsheet Formatting Features

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

Feature	Aspose.Cells for Java	Aspose.Cells for PHP via Java
Apply character formatting in cells including fonts, colors, effects, borders, and shading.
Apply all number format settings (as supported in Microsoft Excel) to cells.
Set all types of text alignment settings.
Apply various font settings to cells.
Apply different colors to cells, fonts, gridlines, graphic objects, etc.
Apply different rich text formatting in a single cell.
Apply various border settings to cells.
Apply different background patterns on cells.
Apply format settings to a worksheet, row, column, or a range of cells, etc.

PageSetup Features

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

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