PHPackages                             iliaal/php-excel - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. iliaal/php-excel

ActivePhp-ext

iliaal/php-excel
================

PHP extension for reading and writing Excel files using LibXL

v2.0.0(1mo ago)5363↑1900%129PHP-3.01CPHP >=8.3CI passing

Since Apr 5Pushed 1mo ago40 watchersCompare

[ Source](https://github.com/iliaal/php_excel)[ Packagist](https://packagist.org/packages/iliaal/php-excel)[ Docs](https://github.com/iliaal/php_excel)[ RSS](/packages/iliaal-php-excel/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (6)DependenciesVersions (5)Used By (0)

php\_excel
----------

[](#php_excel)

[![Tests](https://github.com/iliaal/php_excel/actions/workflows/tests.yml/badge.svg)](https://github.com/iliaal/php_excel/actions/workflows/tests.yml)[![Windows Build](https://github.com/iliaal/php_excel/actions/workflows/windows.yml/badge.svg)](https://github.com/iliaal/php_excel/actions/workflows/windows.yml)[![Version](https://camo.githubusercontent.com/5fed5ef58d4b0226c63702b7993ea5c6aab19815cbe1bc80e429a67deb081305/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f762f72656c656173652f696c6961616c2f7068705f657863656c)](https://github.com/iliaal/php_excel/releases)[![License: PHP-3.01](https://camo.githubusercontent.com/2d0c6e79d68e3ecde571be7a99c822e88c8379ff247dc40dddea7cad6872b8fb/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f4c6963656e73652d5048502d2d332e30312d677265656e2e737667)](http://www.php.net/license/3_01.txt)[![Follow @iliaa](https://camo.githubusercontent.com/a54521c97521f05fbadec4bd9bcba96ff1eeaffe756a6d7338b47a628cdeb39b/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f466f6c6c6f772d40696c6961612d3030303030303f7374796c653d666c6174266c6f676f3d78266c6f676f436f6c6f723d7768697465)](https://x.com/intent/follow?screen_name=iliaa)

PHP extension for reading and writing Excel files (XLS and XLSX) using the [LibXL](http://www.libxl.com/) library.

### Requirements

[](#requirements)

- PHP 8.3+
- [LibXL](http://www.libxl.com/) 4.6.0+ (commercial library)

### Classes

[](#classes)

ClassDescriptionExcelBookWorkbook management: create, load, save, sheets, fonts, formats, picturesExcelSheetCell read/write, formatting, printing, protection, hyperlinks, data validationExcelFormatCell formatting: colors, borders, number formats, alignment, patternsExcelFontFont properties: name, size, bold, italic, underline, colorExcelAutoFilterAutoFilter operations and sortingExcelFilterColumnFilter column criteriaExcelRichStringMixed-font text in a single cellExcelFormControlForm controls: checkboxes, dropdowns, spinners, buttonsExcelConditionalFormatConditional formatting style rulesExcelConditionalFormattingConditional formatting ranges and rule applicationExcelCorePropertiesWorkbook metadata: title, author, dates, categoriesExcelTableStructured table support (xlsx)### Installation

[](#installation)

Via [PIE](https://github.com/php/pie):

```
pie install iliaal/php-excel \
  --with-libxl-incdir=/path/to/libxl/include_c \
  --with-libxl-libdir=/path/to/libxl/lib64
```

Or manually:

```
phpize
./configure --with-excel \
  --with-libxl-incdir=/path/to/libxl/include_c \
  --with-libxl-libdir=/path/to/libxl/lib64
make
make install
```

Add `extension=excel.so` to your `php.ini`.

### Getting started

[](#getting-started)

```