Yii2 导入导出Excel

前两天做excel导入的工作，发现网上关于导出的很多，而导入的几乎寥寥，顺手整理一下导入导出。

yii2 excel导入

$fileName = "/www/test.xlsl";
        $tag_data = moonlandphpexcelExcel::import($fileName, [
            "setFirstRecordAsKeys" => true, 
            "setIndexSheetByName" => true, 
            "getOnlySheet" => "sheet1",
        ]);
//$tag_data = ["mm","xx"];
        //批量插入
        Yii::$app->wxDb->createCommand()->batchInsert(  
            "tag",  
            ["tag_name"],
            $tag_data
        )->execute();

yii2 excel导出

use moonlandphpexcelExcel;
    /*
     * 根据条件导出报名数据
     */
    public function actionPhpexcel($classroom_id) {
        $url =  Yii::$app->request->referrer;

        $enroll = new ClassroomEnroll();
        $enroll = $enroll->find()->all();

        Excel::export([                                                                                                                                                     
            "models" => $enroll,
            "fileName" => $enroll[0]["classroom"]["title"]."-报名",
            "columns" => [
                [  
                    "attribute" => "title",
                    "header" => "课堂",
                    "format" => "text",
                    "value" => function ($models) {
                        return $models["classroom"]["title"];

                    }
                ], 
                [  
                    "attribute" => "order_no",
                    "header" => "订单号",
                    "format" => "paragraphs",
                    "value" => function ($models) {
                        return strip_tags($models["order_no"]);

                    }
                ], 
                [  
                    "attribute" => "price",
                    "header" => "价格",
                    "format" => "text",
                    "value" => function ($models) {
                        return intval($models["price"])>0 ?round($models["price"]/100,2) : $models["price"];

                    }
                ], 
                [  
                    "attribute" => "truename",
                    "header" => "报名者",
                    "format" => "text",
                    "value" => function ($models) {
                        return $models["user"]["truename"];
                    }
                ],
                [  
                    "attribute" => "mobile",
                    "header" => "手机号",
                    "format" => "text",
                    "value" => function ($models) {
                        return $models["user"]["mobile"];
                    }
                ],
                [  
                    "attribute" => "corp",
                    "header" => "公司",
                    "format" => "text",
                    "value" => function ($models) {
                        return $models["user"]["corp"];
                    }
                ],
                [  
                    "attribute" => "position",
                    "header" => "职位",
                    "format" => "text",
                    "value" => function ($models) {
                        return $models["user"]["position"];
                    }
                ],
                [  
                    "attribute" => "status",
                    "header" => "支付状态",
                    "format" => "text",
                    "value" => function ($models) {
                        return $models["order_status"] == 1 ? "已支付" : "未支付";
                    }
                ],
            ]
        ]);
        return yii::$app->util->alert("导出成功",$url);  
    }