yii2::导出Excel

• 第一步：使用composer安装PHPExcel 安装命令：php composer.phar require –prefer-dist moonlandsoft/yii2-phpexcel “*”
  注意 上面的 –prefer 是 - -

• 如果上面的命令有问题请参考下面的网站
  http://www.yiiframework.com/extension/yii2-phpexcel/

• 第二步：引入PHPExcel文件 use moonlandphpexcelExcel;

• 第三步: 编写代码 导出Excel

 public function actionDemo()
    {
        //数据模型
        $enroll = SubscribeUser::find()->all();
        ob_end_clean() ; //解决ob缓存导致导出乱码的问题

        Excel::export([
            "models" => $enroll,
            "fileName" => "test",
            "columns" => [
                [
                    "attribute" => "email",//
                    "header" => "邮箱地址",//excel头
                    "format" => "text",
                    "value" => function ($models) {
                        return $models["email"];
                    }
                ],
                [
                    "attribute" => "type",
                    "header" => "订阅类型",
                    "format" => "text",
                    "value" => function ($models) {
                        return $models["type"];
                    }
                ],
            ],

        ]);
    }