PHPackages                             scotthuangzl/yii2-export2excel - 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. scotthuangzl/yii2-export2excel

ActiveYii2-extension

scotthuangzl/yii2-export2excel
==============================

A behavior to export yii2 query to excel and auto download

831.1k4[1 issues](https://github.com/scotthuangzl/yii2-export2excel/issues)PHP

Since Nov 13Pushed 7y ago2 watchersCompare

[ Source](https://github.com/scotthuangzl/yii2-export2excel)[ Packagist](https://packagist.org/packages/scotthuangzl/yii2-export2excel)[ RSS](/packages/scotthuangzl-yii2-export2excel/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependenciesVersions (1)Used By (0)

Yii2 Export2Excel
=================

[](#yii2-export2excel)

A behavior to export Yii2 query to excel and auto download

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

[](#installation)

The preferred way to install this extension is through [composer](http://getcomposer.org/download/).

Either run

```
php composer.phar require scotthuangzl/yii2-export2excel "dev-master"

```

or add

```
"scotthuangzl/yii2-export2excel": "dev-master"

```

to the require section of your `composer.json` file.

Usage
-----

[](#usage)

In any of your controller:

```
	use scotthuangzl\export2excel\Export2ExcelBehavior;
	public function behaviors()
		{
		//above is your existing behaviors
		//new add export2excel behaviors
				'export2excel' => [
					'class' => Export2ExcelBehavior::className(),
	                //            'prefixStr' => yii::$app->user->identity->username,
                    //            'suffixStr' => date('Ymd-His'),
				],
		}

    public function actions()
    {
        return [
            'error' => [
                'class' => 'yii\web\ErrorAction',
            ],
            'captcha' => [
                'class' => 'yii\captcha\CaptchaAction',
                'fixedVerifyCode' => YII_ENV_TEST ? 'testme' : null,
            ],
			//new add download action
            'download' => [
                'class' => 'scotthuangzl\export2excel\DownloadAction',
            ],
        ];
    }

	//In any of your actions:
	public function actionYoursAnyAction(){
//... your other code
        //test export2excel behavior
        $excel_data = Export2ExcelBehavior::excelDataFormat(EOPStatus::find()->asArray()->all());
        $excel_title = $excel_data['excel_title'];
        $excel_ceils = $excel_data['excel_ceils'];
        $excel_content = array(
            array(
                'sheet_name' => 'EOPStatus',
                'sheet_title' => $excel_title,
                'ceils' => $excel_ceils,
                'freezePane' => 'B2',
                'headerColor' => Export2ExcelBehavior::getCssClass("header"),
                'headerColumnCssClass' => array(
                    'id' => Export2ExcelBehavior::getCssClass('blue'),
                    'Status_Description' => Export2ExcelBehavior::getCssClass('grey'),
                ), //define each column's cssClass for header line only.  You can set as blank.
                'oddCssClass' => Export2ExcelBehavior::getCssClass("odd"),
                'evenCssClass' => Export2ExcelBehavior::getCssClass("even"),
            ),
            array(
                'sheet_name' => 'Important Note',
                'sheet_title' => array("Important Note For Region Template"),
                'ceils' => array(
                    array("1.Column Platform,Part,Region must need update.")
                , array("2.Column Regional_Status only as Regional_Green,Regional_Yellow,Regional_Red,Regional_Ready.")
                , array("3.Column RTS_Date, Master_Desc, Functional_Desc, Commodity, Part_Status are only for your reference, will not be uploaded into NPI tracking system."))
            ),
        );
        $excel_file = "testYii2Save2Excel";
        $this->export2excel($excel_content, $excel_file);
//... your other code
	}

```

Sample picture
--------------

[](#sample-picture)

Please find from: [Yii2 Export2Excel Extension](http://www.yiiframework.com/extension/yii2-export2excel/).

###  Health Score

27

—

LowBetter than 49% of packages

Maintenance18

Infrequent updates — may be unmaintained

Popularity32

Limited adoption so far

Community10

Small or concentrated contributor base

Maturity39

Early-stage or recently created project

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://www.gravatar.com/avatar/4592da36e1c02d2ad5c8bf7754f731a35405e1e51687ff08400220bcbb7bbf12?d=identicon)[ScottHuangZL](/maintainers/ScottHuangZL)

---

Top Contributors

[![ScottHuangZL](https://avatars.githubusercontent.com/u/8861324?v=4)](https://github.com/ScottHuangZL "ScottHuangZL (14 commits)")

### Embed Badge

![Health badge](/badges/scotthuangzl-yii2-export2excel/health.svg)

```
[![Health](https://phpackages.com/badges/scotthuangzl-yii2-export2excel/health.svg)](https://phpackages.com/packages/scotthuangzl-yii2-export2excel)
```

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)