PHP API to Generate & Convert Excel Spreadsheets

Getting Started with Aspose.Cells for PHP via Java

Aspose.Cells for PHP via Java is distributed as a ZIP archive. You need to have PHP 7 or greater versions to be installed. The machine must have Oracle JDK 7 or greater versions before setting up the installation.

Here are the complete installation instructions for Aspose.Cells for PHP via Java.

Create & Manage New Excel Spreadsheet via PHP API

Aspose.Cells for PHP via Java gives software developers the capability to create new Excel spreadsheets inside their own PHP applications. The library also supports opening existing projects, make the require changes to it and update it accordingly. It supports various file formats, such as XLS, XLSX, ODS, SpreadsheetML, CSV, Tab Delimited, HTML/MHTML, PDF, XPS and other formats. The library has included several important features related to documents manipulation, such as adding a copy of existing worksheet, Importing/exporting data from external files, Insert images to spreadsheet, add comments to cells, Merge/split Cells and so on.

// Load the Aspose.Cells library
require_once("path/to/aspose/cells/autoload.php");

use Aspose\Cells\Workbook;
use Aspose\Cells\Worksheets\SheetType;

// Create a new workbook
$workbook = new Workbook();

// Add a new worksheet
$worksheet = $workbook->getWorksheets()->add(SheetType::WORKSHEET);

// Save the workbook
$workbook->save("new-workbook.xlsx");

// add data and formatting to the worksheet
// Add data to cell A1
$worksheet->getCells()->get("A1")->setValue("Hello, World!");

// Save the workbook
$workbook->save("new-workbook.xlsx");

Import & Export Excel File Formats via PHP API

Aspose.Cells for PHP via Java library has included several important features that quickly and reliably, converts between several popular spreadsheet document formats. The library allows to input and out various important spreadsheets file formats, such as XLS, XLSX, XLSB, XLTX, XLTM, XLSM, XML, ODS, CSV, Tab-Delimited, TXT, HTML, MHTML. It also allows export to some popular file formats such PDF, XPS JPEG, PNG, BMP, SVG, TIFF, EMF, GIF and so on.

 use java\io\File;
use com\aspose\cells\Workbook;

// Load the Excel workbook
$workbook = new Workbook(new File("input.xlsx"));

use com\aspose\cells\SaveFormat;

// Save the workbook in PDF format
$workbook->save("output.pdf", SaveFormat::PDF);

Apply Formatting to Spreadsheets via PHP API

Aspose.Cells for PHP via Java makes it easy for computer programmers to apply different types of formatting to their spreadsheets documents. The library has included several important features for handling spreadsheets formatting, such as apply all characters formatting in the cells including fonts, colors, effects, borders and shading, text alignment settings, rich text formatting in a single cell, apply different cells border settings, manage background patterns on cells, apply all the number format settings and many more.

Add Charts & Images in Excel Files via PHP

Aspose.Cells for PHP via Java allows software developers to create and add charts as well as images into spreadsheet documents inside their own PHP applications. The library has included various important for handling charts and images, such as customizing charts, chart formatting types, rendering charts, manage Axes of excel charts, DataLabels & legend handling of Excel charts, add Excel charts titles, Excel 2016 Charts support, get equation Text of Chart Trendline and many more.  

//Load the Excel file
$workbook = new Workbook("input.xlsx");

// add the chart to a worksheet

$chart = $workbook->getWorksheets()->get(0)->getCharts()->addChart(ChartType::COLUMN_CLUSTERED);
$chart->setChartArea(0, 0, 400, 400);
$chart->setPlotArea(0, 0, 350, 350);
$chart->getTitle()->setText("Sales Report");
$chart->getTitle()->getFont()->setSize(12);
$chart->getTitle()->getFont()->setBold(true);
$chart->setLegendShown(true);
$chart->getLegend()->getFont()->setSize(10);

$data = array(
    array("Product", "Sales"),
    array("Product A", 1500),
    array("Product B", 2500),
    array("Product C", 1700),
);

$chart->getNSeries()->add($workbook->getWorksheets()->get(0)->getCells()->importArray($data, '', 'A1'));

$chart->calculate();
$workbook->save("output.xlsx");