Yii2 导入导出Excel

来源：互联网发布：seo网络营销技术编辑：程序博客网时间：2024/06/05 23:03

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

yii2 excel导入

$fileName = '/www/test.xlsl';        $tag_data = \moonland\phpexcel\Excel::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 moonland\phpexcel\Excel;    /*     * 根据条件导出报名数据     */    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);      }

0 0