$user = UserList::find()->where(['id' => $id])->one();

$user->updateCounters(['login_counts'=>1]);

'mailer' => [

          'class' => 'yii\swiftmailer\Mailer',

           'useFileTransport' =>false,

          'transport' => [

              'class' => 'Swift_SmtpTransport',

              'host' => 'smtp.qq.com',

              'username' => 'mymail',

              'password' => 'mymail',

              'port' => '456',

              //'encryption' => 'ssl',

          ],

         'messageConfig'=>[

             'charset'=>'UTF-8',

             'from'=>['mymail@qq.com'=>'zkbhj']

         ],

        ]

$userList = ['zkbhj@qq.com'];

$mail = Yii::$app->mailer;

$mail->useFileTransport = false;

$mail->compose()->setFrom('zkbhj@qq.com')

    ->setTo($userList)

    ->setSubject('数据统计')

    ->setHtmlBody($txt)

    ->send();

Error: Connection could not be established with host smtp.qq.com

phpoffice/phpexcel https://github.com/phpoffice/phpexcel

composer require phpoffice/phpexcel

// 引入PHPExcel库

use PHPExcel; 



public function actionImport(){

	$file = Yii::getAlias("@webroot")."/import_test.xls";

	$objReader = new \PHPExcel_Reader_Excel5();

	$objPHPExcel = $objReader->load($file);

	

	$objWorksheet = $objPHPExcel->getSheet(0);

	//最大行数，为数字

	$highestRow = $objWorksheet->getHighestRow();

	//最大列数 为字母

	$highestColumn = $objWorksheet->getHighestColumn();

	//将字母变为数字

	$highestColumnIndex = \PHPExcel_Cell::columnIndexFromString($highestColumn); 

	

	$tableData = [];

	for($row = 1;$row<=$highestRow;$row++){

		for($col=0;$col< $highestColumnIndex;$col++){

			$tableData[$row][$col] = $objWorksheet->getCellByColumnAndRow($col,$row)->getValue();

		}

	}

	var_dump($tableData);

}

use PHPExcel;

$headerArr = ['优惠券编码'];



$fileName = "export_test.xls";

$objPHPExcel = new PHPExcel();

$objProps = $objPHPExcel->getProperties();



$hk = ord('A');

foreach($headerArr as $v){

    $colum = chr($hk);

    $objPHPExcel->setActiveSheetIndex(0)->setCellValue($colum.'1',$v);

    $hk += 1;

}



$column = 2;

$data = ['adf5t56','5g6HTT4','9QWabh5','xcvTg7'];

$objActSheet = $objPHPExcel->getActiveSheet();

foreach($data as $key => $rows)  //行写入

{

    $span = 0;

    foreach($rows as $keyName => $value) // 列写入

    {

        $j = \PHPExcel_Cell::stringFromColumnIndex($span);

        $objActSheet->setCellValue($j.$column, $value);

        $span++;

    }

    $column++;

}



$objPHPExcel->getActiveSheet()->setTitle('Export Test');

$objPHPExcel->setActiveSheetIndex(0);



header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');

header("Content-Disposition: attachment; filename=\"$fileName\"");

header('Cache-Control: max-age=0');



$writer = \PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel5');

$writer->save('php://output');

//获取验证参数

        $model = \yii\base\DynamicModel::validateData([

            'activity_code' => Yii::$app->getRequest()->post('activity_code'),

            'uid' => Yii::$app->getRequest()->post('uid'),

            'username' => Yii::$app->getRequest()->post('username'),

            'phone' => Yii::$app->getRequest()->post('phone'),

            'answer_1' => Yii::$app->getRequest()->post('answer_1'),

            'answer_2' => Yii::$app->getRequest()->post('answer_2'),

            'answer_3' => Yii::$app->getRequest()->post('answer_3')

        ], [

            [['uid', 'activity_code', 'username', 'phone'], 'required'],

            [['answer_1', 'answer_2', 'answer_3'], 'safe']

        ]);



        if ($model->hasErrors()) {

            FnModel::failureRespone('100001', $model->getErrors());

            Yii::$app->end();

        }

/**

 * 规则

 */

public function rules()

{

    return [

        [['real_name','cert_type','cert_num','gender','phone','user_cert1','user_cert2','user_cert3','is_newsign','house_type'],'safe'],

        [['cert_type','cert_num','real_name'], 'required','on' => self::SCENARIO_INSERT],

        [['cert_type','cert_num','real_name','gender','phone'], 'required','on' => self::SCENARIO_FORSIGN],

        ['cert_type', 'default', 'value' => 0],

        ['cert_type','in', 'range'=>Yii::$app->params['allowCertTypeList'],'on' => [self::SCENARIO_UPDATE,self::SCENARIO_INSERT]],

        ['cert_type','in', 'range'=>[1,2,6,13],'on' => self::SCENARIO_FORSIGN],

        ['gender','in', 'range'=>Yii::$app->params['allowGenderList']],

        ['cert_num', function($attribute) {

            if (isset($this->$attribute) && !isset($this->cert_type)) {

                $this->addError($attribute, '证件类型和证件号码不匹配');

            }

            $is_cert = \apis\modules\account\models\logics\CertLogic::validateCertNum($this->cert_type,$this->$attribute);

            if(!$is_cert){

                $this->addError($attribute, '证件类型和证件号码不匹配');

            }

        }],

        ['cert_type', function($attribute) {

            if($this->$attribute != 1 && (empty($this->user_cert1) || empty($this->user_cert2) || empty($this->user_cert3))){

                $this->addError($attribute, '非身份证用户请上传证件照！');

            }

        },'on' => self::SCENARIO_FORSIGN],            

        [['user_cert1','user_cert2','user_cert3',],'filter', 'skipOnEmpty'=>true, 'filter'=>function($data){

            return \common\models\FnModel::handleUUidToUrl($data); 

        }],

        ['real_name', function($attribute) {

            $is_name = \apis\modules\account\models\logics\CertLogic::validateRealName($this->real_name);

            if(!$is_name){

                $this->addError($attribute, '真实姓名不符合规范');

            }

        },'on' => self::SCENARIO_FORSIGN],  

    ];

}