Aspose.Cells for PHP via Java 18.7 Release Notes

We are pleased to announce the first public release of Aspose.Cells for PHP via Java. The APIs incorporate MS Excel spreadsheet processing functionalities in PHP (a widely-used open source scripting language). Aspose.Cells for PHP via Java is a subset component that includes all the important and useful features present in its native Aspose.Cells for Java. The new API is equally robust and feature rich component. It supports high-fidelity file format conversions to and from XLS, XLSX, XLSM, SpreadsheetML, CSV, Tab Delimited, HTML, MHTML and OpenDocument Spreadsheet in PHP. Please visit Product features comparison page for your reference. Moreover, please see the document on how to Setup environment and other Installation Guidelines for your reference.

Major supported Features

(Please note, not all the features are listed below)

Key Summary Category 

File Formats and Conversions

- XLS, SpreadsheetML (XLSX, XML), Comma Separated Value (CSV), HTML, OpenDocument Spreadsheet (ODS), PDF, Tab Delimited, Plain Text (TXT)

New Feature  

Rendering and Printing

- Render spreadsheet to vector images (EMF)

- Render worksheets to raster images (Multipage TIFF, GIF)

- Render worksheets to raster images (PNG, JPEG, etc.)

- Render Spreadsheet to PDF with high fidelity

New Feature  

Spreadsheet Content Features

- Copy or move worksheets within or between workbooks

- Insert images, Create conventional and custom charts and Set gradient background for charts using API

- Add comments to cells

- Microsoft Excel 2007/2010 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

- Calculate complex Excel formulae

- Support advanced conditional formatting supported in Microsoft Excel 2007/2010

- Freeze/unfreeze Panes

- Insert hyperlinks to link data

- Implement Smart Markers

- Specify document properties settings

- Protect/unprotect worksheets

- Specify advanced protection options introduced in Excel XP and later versions

- Create list object/Microsoft Excel tables

- Create subtotals

- Insert form controls and other drawing shapes/objects

- Create pivot tables and pivot charts

- Preserve or remove addin, VBA, macros

- Manipulate named ranges

- Add, preserve or extract OLE objects from the spreadsheets.

- Implement Microsoft Excel sparklines

- Encrypt files

New Feature  

Spreadsheet Formatting Features

- Apply all characters formatting in the cells including fonts, colors, effects, borders and shading

- Apply all the number format settings (supported in Microsoft Excel) for the cells

- Set all types of text alignment settings

- Apply different kinds of Font Settings for the cells

- Apply different colors to cells, fonts, gridlines, graphic objects etc.

- Apply different rich text formatting in a single cell

- Apply different border settings on cells

- Apply different background patterns on cells

- Apply Format settings on a worksheet, row, column or a range of cells etc.

New Feature  

PageSetup Features

- Adjust your page orientation, scaling, paper size

- Specify your margins and page centering

- Create or edit your header and/or footer

- Set print area, print titles, or turn on gridlines etc.

New Feature