PHPExcel 导出功能做不了 希望朋友们 帮个忙 [发红包] [ 2.0 版本 ]

`

/**
 *
 * 导出Excel
 */

public function actionExport($month){//导出Excel

    $xlsName  = "Staffstatic";
    $xlsCell  = array(
        array('id','序号'),
        array('staffName','姓名'),
        array('staffCode','操作员'),
        array('month','考核月份'),
        array('total','业务量'),
        array('compute','业务量计算数')
    );
 $laws=Protfolio::findOne(1);
 $compute=Staffstatic::find()->select([
     "id",
     "staffCode",
     "staffName",
     "month",
     "createTime",
     "sum(total)",
 ])->groupBy(['staffName','staffCode'])->where(['month'=>$month])->asArray()->all();
 $xlsData=null;
 foreach ($compute as $key=>$v){
     $xlsData[]=array(
         "id"=>$v["id"],
         "staffCode"=>$v["staffCode"],
         "staffName"=>$v["staffName"],
         "month"=>$v["month"],
         "createTime"=>$v["createTime"],
         "total"=>$v["sum(total)"],
         "compute"=>$v["sum(total)"]*$laws['protfolio']
     );
    }

    $this->exportExcel($xlsName,$xlsCell,$xlsData);
}

public function exportExcel($xlsName,$xlsCell,$xlsData){

    header("Content-type:text/html;charset=utf-8");
    set_time_limit(0);
    require dirname(dirname(__DIR__)).'/vendor/PHPExcel/PHPExcel.php';
    $xlsTitle = iconv('utf-8', 'gb2312', $xlsName);//文件名称
    $fileName = date('YmdHis');//or $xlsTitle 文件名称可根据自己情况设定
    $cellNum = count($xlsCell);
    $dataNum = count($xlsData);
    $objPHPExcel = new \PHPExcel();
    $objPHPExcel = new \PHPExcel();
    $cellName = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','AA','AB','AC','AD','AE','AF','AG','AH','AI','AJ','AK','AL','AM','AN','AO','AP','AQ','AR','AS','AT','AU','AV','AW','AX','AY','AZ');

// $objPHPExcel->getActiveSheet(0)->mergeCells('A1:'.$cellName[$cellNum-1].'1');//合并单元格

     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', $xlsName.'  Export time:'.date('Y-m-d H:i:s'));
    for($i=0;$i<$cellNum;$i++){
        $objPHPExcel->setActiveSheetIndex(0)->setCellValue($cellName[$i].'2', $xlsCell[$i][1]);
    }
    // Miscellaneous glyphs, UTF-8
    for($i=0;$i<$dataNum;$i++){
        for($j=0;$j<$cellNum;$j++){
            $objPHPExcel->getActiveSheet(0)->setCellValue($cellName[$j].($i+3), $xlsData[$i][$xlsCell[$j][0]]);
        }
    }

    header('pragma:public');
    header('Content-type:application/vnd.ms-excel;charset=utf-8;name="'.$xlsTitle.'.xls"');
    header("Content-Disposition:attachment;filename=$fileName.xls");//attachment新窗口打印inline本窗口打印
    $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
    exit();
    $objWriter->save('php://output');

}

`

我终于搞定了 谢谢你们宝贵的意见 提议