PHPackages                             sunyujin/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. sunyujin/yii2-excelexport

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

sunyujin/yii2-excelexport
=========================

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

1.0.0(3y ago)00MITPHP >=7.2

Since Jan 18Pushed 3y agoCompare

[ Source](https://github.com/xiaoxu9156/yii2-excelexport)[ Packagist](https://packagist.org/packages/sunyujin/yii2-excelexport)[ RSS](/packages/sunyujin-yii2-excelexport/feed)WikiDiscussions 1.0 Synced 1mo ago

READMEChangelogDependencies (3)Versions (3)Used By (0)

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

[](#yii2-excel-export)

[![Latest Stable Version](https://camo.githubusercontent.com/f69383f5356c564e9032d42f70a65775e61c5ab9d55e5ae49c37f4862ecf606e/68747470733a2f2f706f7365722e707567782e6f72672f73756e79756a696e2f796969322d657863656c6578706f72742f762f737461626c65)](https://packagist.org/packages/sunyujin/yii2-excelexport)[![Total Downloads](https://camo.githubusercontent.com/df825af0119c222cef1c7516d4c02e41915a43ee43660ae2b90b9b15a7c21ec3/68747470733a2f2f706f7365722e707567782e6f72672f73756e79756a696e2f796969322d657863656c6578706f72742f646f776e6c6f616473)](https://packagist.org/packages/sunyujin/yii2-excelexport)[![Latest Unstable Version](https://camo.githubusercontent.com/c2cdbdbaca4d777986f392f44cca1b97e473f22ac94206cf0cbf6d11816d72ae/68747470733a2f2f706f7365722e707567782e6f72672f73756e79756a696e2f796969322d657863656c6578706f72742f762f756e737461626c65)](https://packagist.org/packages/sunyujin/yii2-excelexport)[![License](https://camo.githubusercontent.com/ce764720ea0128ce785aa007e58d59675d1cdb92d65ca5980a77dd58e17b1a31/68747470733a2f2f706f7365722e707567782e6f72672f73756e79756a696e2f796969322d657863656c6578706f72742f6c6963656e7365)](https://packagist.org/packages/sunyujin/yii2-excelexport)

> **Note:** Fork 自 [code1mix/yii2-excelexport](https://github.com/code1mix/yii2-excelexport) 项目，仅做简单修改以支持在 php7.2 版本下使用。 在此感谢原作者提供了如此优秀的开源项目

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 sunyujin/yii2-excelexport

```

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

[](#quickstart-example)

```