PHP Excel Spreadsheet API

Perform spreadsheet manipulation tasks as well as export Excel files to multiple formats without any Microsoft Excel dependencies.

  Download Free Trial
Aspose.Cells for PHP via Java

Aspose.Cells for PHP via Java

 
 

Aspose.Cells for PHP via Java is a scalable and feature-rich Excel spreadsheet management and processing API. Applications can perform spreadsheet format conversion, chart management and rendering, implementing formulas, styling of worksheets to the most granular level and much more. API supports XLS, XLSX, ODS, SpreadsheetML, CSV, Tab Delimited, HTML/MHTML, PDF, XPS and other formats. Developers can easily add the ability to create, edit, convert and render Excel files in their PHP applications while using the JavaBridge.

 

Advanced PHP Spreadsheet API Features

 

 

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.

Save spreadsheet in multiple formats - PHP

// 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.

 

Support and Learning Resources