PHPackages                             lyquidity/php-pivottables-4-excel-lite - 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. [Utility & Helpers](/categories/utility)
4. /
5. lyquidity/php-pivottables-4-excel-lite

ActiveLibrary[Utility & Helpers](/categories/utility)

lyquidity/php-pivottables-4-excel-lite
======================================

Adds limited Excel pivot table functionality to PHPOffice/PHPSpreadsheet

175879[2 issues](https://github.com/bseddon/php-pivottables-4-excel-lite/issues)PHP

Since Nov 27Pushed 4y ago1 watchersCompare

[ Source](https://github.com/bseddon/php-pivottables-4-excel-lite)[ Packagist](https://packagist.org/packages/lyquidity/php-pivottables-4-excel-lite)[ RSS](/packages/lyquidity-php-pivottables-4-excel-lite/feed)WikiDiscussions master Synced today

READMEChangelogDependenciesVersions (2)Used By (0)

PHP Pivot Tables for Excel - Lite
=================================

[](#php-pivot-tables-for-excel---lite)

PHPOffice/PhpSpreadsheet is a great project to read and write Excel workbook but it does not support some Excel features such as Tables and Pivot Tables. This project extends PhpSpreadsheet by adding support for pivot tables but only in a limited way.

What is supported?
------------------

[](#what-is-supported)

This project ensures that existing pivot tables are retained and allows pivot tables to be created to report on data in worksheets.
The rows and columns can be defined based on columns in the worksheet and they can be filtered and sorted. Only Xlsx/Xlsm files are supported.

What is not supported?
----------------------

[](#what-is-not-supported)

The pivot table features not supported include:

- External data sources
- Styling
- Hierarchies
- Formulas
- File types other than Xlsx

However, there is no reason why support for these features cannot be added and the project shows how additional features can be implemented.

Installing
==========

[](#installing)

Use composer with the command:

```
composer require lyquidity/php-pivottables-4-excel-lite:dev-master --prefer-dist

```

Getting started
===============

[](#getting-started)

The ./examples/example.php file includes illustrations of using the classes.

Assuming you have installed the library using composer then this PHP application will run the test:

```