Excel spreadsheets are a vital tool for businesses and individuals alike when it comes to data management, analysis, and reporting. Creating and manipulating Excel files programmatically can be a common requirement in various web applications. In this blog post, we will explore how to create Excel files in PHP leveraging Aspose.Cells for PHP - a powerful and feature-rich library for Excel automation.
- PHP Library to Create Excel Files
- Create an Excel Files in PHP
- Modify an Excel File in PHP
- Create Excel File with Charts or Graphs
- Create a Table in an Excel File
- Create Excel Files Online
PHP Excel Library
Aspose.Cells for PHP is a robust PHP library that enables developers to create, manipulate, and convert Excel files programmatically. It offers a wide range of features, including the ability to generate Excel worksheets, format cells, insert charts, and perform advanced data analysis. With Aspose.Cells for PHP, you can automate Excel-related tasks within your PHP application.
You can download the library package from here.
Usage
The following are the prerequisites that you need to fulfill in order to use Aspose.Cells for PHP.
Once you have completed the prerequisites, follow the below steps to execute the example.php file for testing.
- Place Java.inc file in the root folder of the library’s package that you have downloaded.
- Run JavaBridge.jar using the below commands in the command prompt:
cd aspose.cells
%JAVA_HOME%\bin\java -Djava.ext.dirs=lib -jar JavaBridge.jar SERVLET_LOCAL:8080
- Run example.php from the library’s root folder using the below command:
php example.php
Create an Excel File in PHP
The following are some easy steps to create an Excel file in a PHP application.
- Create an object of Workbook class.
- Access the WorksheetCollection using $workbook->getWorksheets() method.
- Access Cells collection of the desired worksheet using $worksheets->get(index)->getCells() method.
- Insert value into the desired cell using $cells->get(“A1”)->putValue(“Hello world!”) method.
- Save the Excel workbook using $workbook->save(“output.xlsx”, cells\SaveFormat::XLSX) method.
The following code sample shows how to create an Excel XLSX file in PHP.
Edit an Excel File in PHP
In the previous section, we created an Excel file from scratch. Now, let’s edit an existing Excel file and insert data into it.
The following are the steps to write data to an XLSX file using Aspose.Cells for PHP via Java.
- Create an object of Workbook class and initialize it with the path to the Excel file.
- Access the WorksheetCollection of the Excel file using $workbook->getWorksheets() method.
- Access Cells collection of the desired worksheet using $worksheets->get(index)->getCells() method.
- Insert value into the desired cell using $cells->get(“A1”)->putValue(“Hello world!”) method.
- Save the Excel workbook using $workbook->save(“output.xlsx”, cells\SaveFormat::XLSX) method.
The following code sample shows how to modify an Excel file in PHP.
Add a Chart in an Excel File
The following are the steps to create charts in an Excel file using PHP.
- Create a new Excel file or load an existing one using the Workbook class.
- Add data to the worksheet if a new workbook is created.
- Get the chart collection of the worksheet using the $worksheet->getCharts() method.
- Add a new chart using $worksheet->getCharts()->add() method.
- Get the newly created Chart from the collection.
- Specify the cells’ range to set NSeries for the chart.
- Save the workbook as an Excel .xlsx file using $workbook->save(“output.xlsx”, cells\SaveFormat::XLSX) method.
The following code sample shows how to create charts in Excel files in PHP.
Add a Pivot Table in an Excel File in PHP
Pivot tables in Excel worksheets are used for adding filters to the data, computing totals, summarizing data, etc. Pivot tables can be created using the range of the cells in the worksheet. The following are the steps to create a pivot table in an Excel worksheet using PHP.
- Create a new Excel file or load an existing one using the Workbook class.
- Insert data into the worksheet.
- Access the pivot table collection using $worksheet->getPivotTables() method.
- Add a new pivot table in the worksheet using $worksheet->getPivotTables()->add() method.
- Provide data to the pivot table.
- Save the workbook using $workbook->save(“output.xlsx”, cells\SaveFormat::XLSX) method.
The following code sample shows how to create a pivot table in Excel using PHP.
Online Excel Editor
We also provide an online Excel editor for you to create and edit Excel files. You can use this powerful spreadsheet editor without creating an account.
Get Free PHP Excel Library
You can create Excel files in PHP for free without evaluation limitations using a free temporary license.
Conclusion
Aspose.Cells for PHP is a powerful library that simplifies Excel file generation and manipulation in PHP applications. In this blog post, we’ve covered the basics of creating Excel files and adding charts and table using Aspose.Cells for PHP. Furthermore, you have seen how to write data to an existing Excel file.
This library offers numerous advanced features, such as performing numerical operations, data analysis, and Excel file conversion, making it a versatile choice for any PHP project that involves Excel automation. To explore further, refer to the official Aspose documentation. In case you would have any questions, feel free to let us know via our forum.