Features

Aspose.Cells for PHP via Java Features Overview

This section provides a comparison of 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. tick tick
Microsoft Excel Workbook (XLS) The fastest and most complete XLS format implementation you can find. tick tick
SpreadsheetML (XLSX, XML) Aspose.Cells supports OOXML, Flat OPC and also Excel 2003 XML. Moreover,
the component supports all major Excel 2007 and later versions file formats e.g XLSX, XLTX, XLSM, XLTM etc.
tick tick
Comma Separated Value (CSV) Comprehensive support of the CSV format to interact with a variety of applications. tick tick
HTML Save as HTML is available. tick tick
OpenDocument (ODS) Aspose.Cells can load and save documents in the OpenDocument Spreadsheet (.ods) format. tick tick
Adobe Portable Document Format (PDF) Convert any Spreadsheet to PDF with high fidelity. tick tick
Tab Delimited Load and save documents in the tab delimited file format. tick tick
Plain Text (TXT) Easily extract text by saving in plain text format. tick tick

Rendering and Printing

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

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

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 given in the below table.

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

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 all characters formatting in the cells including fonts, colors, effects, borders and shading. tick tick
Apply all the number format settings (supported in Microsoft Excel) for the cells. tick tick
Set all types of text alignment settings. tick tick
Apply different kinds of Font Settings for the cells. tick tick
Apply different colors to cells, fonts, gridlines, graphic objects etc. tick tick
Apply different rich text formatting in a single cell. tick tick
Apply different border settings on cells. tick tick
Apply different background patterns on cells. tick tick
Apply Format settings on a worksheet, row, column or a range of cells etc. tick tick

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 your page orientation, scaling, paper size. tick tick
Specify your margins and page centering. tick tick
Create or edit your header and/or footer. tick tick
Set print area, print titles, or turn on gridlines etc. tick tick