yii2.0--导出为excel文件

安装PHPExcel扩展

    "require": {
        "php": ">=5.4.0",
        "yiisoft/yii2": "~2.0.14",
        "yiisoft/yii2-bootstrap": "~2.0.0",
        "yiisoft/yii2-swiftmailer": "~2.0.0",
        "phpoffice/phpexcel": "^1.8",
    },

/**
     * 导出
     * @author zcy
     * @date 2019/8/16
     * @throws \PHPExcel_Exception
     * @throws \PHPExcel_Reader_Exception
     * @throws \PHPExcel_Writer_Exception
     */
    public function actionExcelExport()
    {
        $objExcel = new \PHPExcel();

        $data = UsersInfo::find()->all();

        $objExcel->setActiveSheetIndex(0)
            ->setCellValue('A1','店名')
            ->setCellValue('B1','店面类型')
            ->setCellValue('C1','添加时间')
        ;
        $i=2;

        foreach ($data AS $k=>$v) {
            $objExcel->getActiveSheet()
                ->setCellValue('A'.$i,$v['shop_name'])
                ->setCellValue('B'.$i,$v['shop_type'])
                ->setCellValue('C'.$i,$v['add_time']);
            $i++;
        }

        $objActSheet = $objExcel->getActiveSheet();

        //设置表格名称
        $objActSheet->setTitle('ShopInfo');

        //生成文件
        $objWriter = \PHPExcel_IOFactory::createWriter($objExcel,'Excel2007');
        $path = 'upload/Files/';
        if (!is_dir($path)) {
            mkdir($path,0777,true);
        }
        $objWriter->save($path . 'myexcel' . '.xlsx');
//        header('Content-Type:application/vnd.ms-excel');
//        header('Content-Disposition:attachment;filename="01simple.xls"');
//        header('Cache-Control:max-age=0');
//        $objWriter =\PHPExcel_IOFactory::createWriter($objExcel, 'Excel5');
//        $objWriter->save('php://output');
//        return $this->render($this->actionID);
    }