phpexcel导出复杂样式excel

后端采用tp5框架，最好使用composer在tp5根目录引入phpexcel，在vendor目录下生成，引用时‘use \PHPExcel‘即可。

具体操作为：到Packagist官网https://packagist.org/packages/phpoffice/复制phpexcel加载指令，composer require phpoffice/phpexcel，项目根目录运行。

此样式用到的类为：

use \PHPExcel;
use \PHPExcel_Style_Color;
use \PHPExcel_Style_Alignment;
use \PHPExcel_style_Fill;

具体php代码：

public function exportExcel($pid)
{
    $model = Promodel::getInstance();
    $shop = $model->shopName($pid);
    $data = $model->excData($pid);
    $objPHPExcel = new \PHPExcel();
    $objWriter = new \PHPExcel_Writer_Excel2007($objPHPExcel);
    ob_end_clean();//清空缓存
    header("Pragma: public");//设置头信息
    header("Expires: 0");
    header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
    header("Content-Type:application/force-download");
    header("Content-Type:application/vnd.ms-execl");
    header("Content-Type:application/octet-stream");
    header("Content-Type:application/download");
    header('Content-Disposition:attachment;filename="表单.xls"');
    header("Content-Transfer-Encoding:binary");
    $arr = ['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'];//excel列名数组
    $col = $data['period'] * 3;//数据列数，天数三倍
    $hournum = count($data['h