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.
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, GIF
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.
Aspose.Cells offers individual Excel APIs for other popular development environments as listed below: