Open Source PHP API for XLSX Excel Spreadsheet
create, edit and manage Excel-compatible spreadsheet in XLSX format online via open source PHP library.
The PHP_XLSXWriter is a very powerful open source API that gives software developers the capability to create and manage Excel spreadsheets online inside their own PHP applications. The library provides support for generating Microsoft Excel-compatible spreadsheets in (Office 2007+) XLSX format. The library is very lightweight and is designed to use a very lesser amount of memory.
The PHP_XLSXWriter library has included support for very valuable operations related to Excel XLSX files creation and management, such as accessing and reading existing XLSX files, writing huge 100K+ row spreadsheets, accessing a specific row or column of a worksheet, modifying the existing spreadsheet, add new rows or columns, manage multiple worksheets, adding new worksheets to a workbook, currency support, using date, numeric cell formatting support, simple formulas, basic cell styling support, and many more.
The library is very stable and produces high performance and lesser cost as compared to several other available spreadsheets libraries. It has the capability of writing large XLSX spreadsheet files with high speed and less memory usage
At A Glance
An overview of PHP_XLSXWriter features.
- Create Excel XLSX
- Modify XLSX
- Read XLSX file
- Manage Cells
- Add new rows
- access specific row
- access a column
- Insert Columns
- add worksheets
- Style support
PHP_XLSXWriter only requires PHP >= 5.2.
- PHP >= 5.2
Getting Started with PHP_XLSXWriter
The recommended way to install PHP_XLSXWriter library is by using GitHub. Please use the following command for smooth installation.
Install PHP_XLSXWriter via Git
gh repo clone mk-j/PHP_XLSXWriter
Create Excel Spreadsheet via PHP
The open source PHP_XLSXWriter enables software developers to create web apps with the capability to generate a new XLSX spreadsheet with just a couple of lines of PHP code. Developers can also easily insert a new worksheet with all basic features. The library allows to add new rows or columns, insert data into existing sheets, apply basic formulas, modify data in the cells, apply formatting to the new cells, delete an existing worksheet, and so on.
Read or Modify Existing Spreadsheets
The PHP_XLSXWriter library has included support for accessing as well as modifying the existing spreadsheet documents using PHP commands. To modify an existing spreadsheet file first you need to open it and apply the changes according to your needs. You can apply basic formatting to your cells, insert a new row or columns, merge rows, enhance borders, change font size, and much more.
Manage Cell Formatting and Styles via PHP
The open source PHP_XLSXWriter library gives software developers the capability to apply different kinds of cell formatting in their Excel XLSX document. The library has provided support for basic as well as advanced cell formats such as string, integer, date, datetime, price, time, dollar, and more. The basic cell styles such as font, font-size, border style, border-color, fill, halign and valign have been available from the earlier versions.