PHP library to manipulate Excel spreadsheets
Dynamically Create, Manipulate or Convert Excel Spreadsheets in PHP applications without requiring Microsoft Excel.Download Free Trial
Aspose.Cells for PHP via Java
Aspose.Cells for PHP via Java is an Excel Spreadsheet Processing API that allows the developers to add the ability to read, write, convert and manipulate Excel spreadsheets in their on PHP applications while using the JavaBridge.
Aspose.Cells for PHP via Java is a scalable and feature rich API that offers spreadsheet format conversion, styling of worksheets to the most granular level, chart management & rendering, and our world renowned Formula Calculate Engine.
At A Glance
An overview of Aspose.Cells for PHP via Java capabilities.
- Convert Chart to Image
- Convert Worksheet to Image
- Convert Spreadsheet to PDF
- Formula Calculation
- Smart Markers
- Pivot Tables
- Conditional Formatting
Aspose.Cells for PHP via Java requires PHP 7.1 (or above) and JavaBridge. It can run on any platform where these requirements can be met.
Supported File Formats
Aspose.Cells for PHP via Java supports the popular spreadsheet formats along with most commonly used image & fixed-layout formats.
- Microsoft Excel: XLS, XLSX, XLSB, XLTX, XLTM, XLSM, XML
- OpenOffice: ODS
- Text: CSV, Tab-Delimited, TXT
- Web: HTML, MHTML
- Fixed Layout: PDF, XPS
- Images: JPEG, PNG, BMP, SVG, TIFF, EMF
Advanced PHP Excel 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 & 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 Spreadsheets to PDF, XPS & HTML Formats
Aspose.Cells for .NET is capable of converting spreadsheets to PDF, XPS & HTML formats while maintaining the highest visual fidelity. The conversion process is simple yet reliable, thus making Aspose.Cells a perfect choice for the organizations which require to exchange documents in any of the industry standard formats.
Save spreadsheet in different formats - PHP
// load file to be converted $workbook = new Workbook("template.xlsx"); // save in different formats $workbook->save("output.pdf", SaveFormat::PDF); $workbook->save("output.xps", SaveFormat::XPS); $workbook->save("output.html", SaveFormat::HTML);
Render Excel Spreadsheets & Objects
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 the 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
Aspose.Cells for PHP via Java gives you complete freedom and flexibility to furnish your spreadsheets with all kinds of visual effects. The PHP Spreadsheet API allows you to 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, charts and graphics are visually appealing and can give your spreadsheet a professional look. Aspose.Cells for PHP via Java provides a comprehensive set of APIs for creating and manipulating all types of standard and custom chart. Moreover, you may add different types of drawing objects, such as comments, pictures, OLE objects, shapes and controls to the cells.
Aspose.Cells offers individual Excel APIs for other popular development environments as listed below: