PHPackages                             codemix/yii2-excelexport - 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. [PDF & Document Generation](/categories/documents)
4. /
5. codemix/yii2-excelexport

ActiveYii2-extension[PDF & Document Generation](/categories/documents)

codemix/yii2-excelexport
========================

A utility to quickly create Excel files from query results or raw data

2.8.4(5mo ago)105391.8k↓40.6%32[1 issues](https://github.com/codemix/yii2-excelexport/issues)MITPHPPHP >=7.4

Since Apr 28Pushed 5mo ago10 watchersCompare

[ Source](https://github.com/codemix/yii2-excelexport)[ Packagist](https://packagist.org/packages/codemix/yii2-excelexport)[ RSS](/packages/codemix-yii2-excelexport/feed)WikiDiscussions master Synced 3d ago

READMEChangelog (10)Dependencies (3)Versions (20)Used By (0)

Yii2 Excel Export
=================

[](#yii2-excel-export)

[![Latest Stable Version](https://camo.githubusercontent.com/55f571f08c2dd5619baf476bdcf1a981f49e0ccbefa2bf5060f96624d2c6dbfe/68747470733a2f2f706f7365722e707567782e6f72672f636f64656d69782f796969322d657863656c6578706f72742f762f737461626c65)](https://packagist.org/packages/codemix/yii2-excelexport)[![Total Downloads](https://camo.githubusercontent.com/0e71f6825b7026de2cf913f0e9278fea881d3cfd29b436bc60d739657c751b3f/68747470733a2f2f706f7365722e707567782e6f72672f636f64656d69782f796969322d657863656c6578706f72742f646f776e6c6f616473)](https://packagist.org/packages/codemix/yii2-excelexport)[![Latest Unstable Version](https://camo.githubusercontent.com/b80343a664807fcd1edddf1f1c4427fa00d63927daddf336bbc8ca94ecd6e75a/68747470733a2f2f706f7365722e707567782e6f72672f636f64656d69782f796969322d657863656c6578706f72742f762f756e737461626c65)](https://packagist.org/packages/codemix/yii2-excelexport)[![License](https://camo.githubusercontent.com/fc29c64b2820708254fe1aa47e77262c0ca431e2eba919fd9c9b2bf17936240b/68747470733a2f2f706f7365722e707567782e6f72672f636f64656d69782f796969322d657863656c6578706f72742f6c6963656e7365)](https://packagist.org/packages/codemix/yii2-excelexport)

> **Note:** The minimum requirement since 2.6.0 is Yii 2.0.13. The latest version for older Yii releases is 2.5.0.

Features
--------

[](#features)

- Export data from `ActiveQuery` results
- Export any other data (Array, Iterable, ...)
- Create excel files with multiple sheets
- Format cells and values

To write the Excel file, we use the excellent [PHPSpreadsheet](https://github.com/PHPOffice/PhpSpreadsheet) package.

Installation
------------

[](#installation)

Install the package with [composer](http://getcomposer.org):

```
composer require codemix/yii2-excelexport

```

Quickstart example
------------------

[](#quickstart-example)

```