PHP Excel Spreadsheet API

Support for CSV, Tab-delimited & HTML formats

Load & save OpenDocument Spreadsheet (ODS) format

Create, manipulate & render charts

Import formulas from a designer spreadsheet

Configure page setup

Create and manipulate comments

Set auto-filters & page breaks

Set & calculate complex formulas

Create & manipulate conditional formatting rules

Set security/protection options

Create & manipulate named ranges

Populate worksheets through Smart Markers

Create, manipulate & refresh Pivot Tables

Export worksheets in SVG format

Create & render sparklines

Convert Excel Files to XPS, PDF & HTML

Aspose.Cells for PHP via Java API is capable of Excel files conversion to XPS, XPS and HTML formats as well as keeping the highest visual fidelity. The conversion process is reliable and developers can get the required format with just a few lines.

// load document to be converted

$wkbk = new Workbook("template.xlsx");



// save in various formats

$wkbk->save("output.pdf", SaveFormat::PDF);

$wkbk->save("output.xps", SaveFormat::XPS);

$wkbk->save("output.html", SaveFormat::HTML);

Render Excel Spreadsheets & Objects to PDF & Images

Aspose.Cells for PHP via Java has its own rendering engine specially designed for rendering with highest of fidelity to the Microsoft Excel. While using Aspose.Cells for PHP via Java, you can convert whole spreadsheets, individual worksheets & charts to a number of image & fixed-layout formats.

Flexible Worksheet Display Options

Aspose.Cells for PHP via Java gives you complete control over the worksheet's page setup thus allowing you to manipulate Excel worksheet's display options such as page breaks, page orientation, scaling, paper size, headers/footers & zoom level. You may also control the data visibility using freeze panes & print area to suit your application requirements.

Efficient, Robust & Reliable Formula Calculation Engine

Aspose.Cells for PHP via 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.

Visualize Data with Formatting, Charts & Graphics

The library is so flexible that one can furnish spreadsheets with all kinds of visual effects as well as can 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, for a professional look and easy understanding charts and graphics are the integral parts. Aspose.Cells for PHP via Java APIs can create and manipulate all types of standard and custom charts. Furthermore, different types of drawing objects to the cells can easily be added.