This package is not installable via Composer 1.x, please make sure you upgrade to Composer 2+. Read more about our Composer 1.x deprecation policy.

A behavior to export yii2 query to excel and auto download

Installs: 19

Dependents: 0

Suggesters: 0

Security: 0

Stars: 0

Watchers: 2

Forks: 0


dev-master 2018-10-11 03:00 UTC

This package is not auto-updated.

Last update: 2021-11-24 15:04:10 UTC


A behavior to export Yii2 query to excel and auto download !


The preferred way to install this extension is through composer.

Either run

composer require --prefer-dist izisoft/yii2-export2excel "dev-master"

or add

"izisoft/yii2-export2excel": "dev-master"

to the require section of your composer.json file.


In any of your controller:

	use izisoft\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' => 'izisoft\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(
                '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"),
                '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

Please find from: Yii2 Export2Excel Extension.

Xem thêm các dự án viết bằng yii framework

Kho hàng US - Dịch vụ đặt hàng Mỹ số 1 Việt Nam

Mỹ phẩm cao cấp Hàn Quốc Amaranth - Sorabee - Bello Vita

Chia sẻ kinh nghiệm lập trình php - vps - hosting

Chia sẻ coupon khuyến mãi từ các trang thương mại điện tử hàng đầu tại Việt Nam và trên toàn thế giới

EMZ - Mua gì cũng có

Thao Chip Shop, Chuyên bán buôn, bán lẻ đồ ngủ nữ