phpexcel 各种样式设置

public function excel() {
        require_once 'Classes/PHPExcel/IOFactory.php';
        $path = dirname(__FILE__); //找到当前脚本所在路径
        $PHPExcel = new \PHPExcel(); //实例化PHPExcel类，类似于在桌面上新建一个Excel表格
        $PHPSheet = $PHPExcel->getActiveSheet(); //获得当前活动sheet的操作对象
        $PHPSheet->setTitle('0'); //给当前活动sheet设置名称
        $PHPSheet->getStyle("A1:AH1")->getFont()->setSize(14);//字体大小
        $PHPSheet->getRowDimension('1')->setRowHeight(65);//高度
        for ($i = ord("a"); $i <= ord("z"); $i++) {
            $ii = strtoupper(chr($i));
            $PHPSheet->getColumnDimension($ii)->setWidth(12);//宽度
        }
        for ($i = ord("a"); $i <= ord("h"); $i++) {
            $ii = strtoupper(chr($i));
            $PHPSheet->getColumnDimension('A' . $ii)->setWidth(12);
        }

        $styleArray = array(
            'borders' => array(
                'allborders' => array(
                    'style' => \PHPExcel_Style_Border::BORDER_THIN, //边框是粗的
                    'color' => array('rgb' => '000000'), // 绿色
                ),
            ),
        );

        $PHPSheet->getStyle('A1:AH1')->applyFromArray($styleArray);//边框颜色

        $PHPSheet->getStyle("A1:AH1")->getFont()->setBold(true);//字体加粗
        $PHPSheet->getStyle("A1:AH1")->getAlignment()->setWrapText(true);//自动划行
        $PHPSheet->getStyle("A1:AH1")->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);//垂直居中
        $PHPSheet->getStyle("A1:AH1")->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//水平居中
        $PHPSheet->getStyle("A1:AH1")->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setRGB('C0C0C0');//背景颜色

        $PHPWriter = \PHPExcel_IOFactory::createWriter($PHPExcel, 'Excel2007'); //按照指定格式生成Excel文件，'Excel2007'表示生成2007版本的xlsx，'Excel5'表示生成2003版本Excel文件
        header('Content-Disposition: attachment;filename="用户信息.xlsx"');
        header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
        $PHPWriter->save("php://output");
    }