PHPEXCEL封装的方法 直接调用

public function exportExcel($title=array(), $data=array(), $fileName=’’, $savePath=’./’, $isDown=true)
{
Loader::import(‘PHPExcel.Classes.PHPExcel’);
Loader::import(‘PHPExcel.Classes.PHPExcel.IOFactory’);
$obj = 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');
// $data1=time();
$obj->getActiveSheet(0)->setTitle('sheet1名称');   //设置sheet1名称
$_row = 1;   //设置纵向单元格标识
if($title){
    $_cnt = count($title);
    // 第一行的合并 可以不要
    // $obj->getActiveSheet(0)->mergeCells('A'.$_row.':'.$cellName[$_cnt-1].$_row);   //合并单元格
    // $obj->setActiveSheetIndex(0)->setCellValue('A'.$_row, '数据导出：'.date('Y-m-d H:i:s'));  //设置合并后的单元格内容
    // $_row++;
    $i = 0;
    foreach($title AS $v){   //设置列标题
        $obj->setActiveSheetIndex(0)->setCellValue($cellName[$i].$_row, $v);
        $i++;
    }
    $_row++;
}

//填写数据
if($data){
    $i = 0;
    foreach($data AS $_v){
        $j = 0;
        foreach($_v AS $_cell){
            $obj->getActiveSheet(0)->setCellValue($cellName[$j] . ($i+$_row), $_cell);
            $j++;
        }
        $i++;
    }
}

//文件名处理
if(!$fileName){
    $fileName = uniqid(time(),true);
}

$objWrite = \PHPExcel_IOFactory::createWriter($obj, 'Excel2007');

if($isDown){   //网页下载
    header('pragma:public');
    header("Content-Disposition:attachment;filename=$fileName.xls");
    $objWrite->save('php://output');exit;
}

$_fileName = iconv("utf-8", "gb2312", $fileName);   //转码
$_savePath = $savePath.$_fileName.'.xlsx';
 $objWrite->save($_savePath);

 return $savePath.$fileName.'.xlsx';

}