phpexcel导入导出excel，并解决超出26列出现的错误

Thinkphp  
$lists = '';             //sql查询结果;

  $total_money = '';
  $filename="order_excel"; // 文件名称
  $headArr=array("ID","用户名称","专家名称","专家订单","订单价格","消费类型","订单类型","订单时间","订单有效期");      
  $title = "订单明细";     //  文件标题
  $total_name = '总金额';
  $this->exportExcel($filename,$title,$headArr,$order_listss,$total_name,$total_money);

第一种：

function exportExcel($filename,$expTitle,$expCellName,$expTableData,$total_name='',$total_money='')

{
        $xlsTitle = iconv('utf-8', 'gb2312', $expTitle);//文件名称
        $fileName = $filename.date('_YmdHis');//or $xlsTitle 文件名称可根据自己情况设定
        $cellNum = count($expCellName);
        $dataNum = count($expTableData);

        Vendor("PHPExcel.PHPExcel");
        Vendor("PHPExcel.PHPExcel.Writer.Excel5");
        Vendor("PHPExcel.PHPExcel.PHPExcel.IOFactory.php");
        $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', $expTitle.'  Export time:'.date('Y-m-d H:i:s'));  
        for($i=0;$i<$cellNum;$i++){
            $objPHPExcel->setActiveSheetIndex(0)->setCellValue($cellName[$i].'2', $expCellName[$i]); 
        } 
        $column = 3;
        $objActSheet = $objPHPExcel->getActiveSheet(0);
        foreach($expTableData as $keys => $rows){ 
            $span = ord("A");
            foreach($rows as $keyName=>$value){
                $j = chr($span);
                $objActSheet->setCellValue($j.$column, $value);
                $span++;
            }
            $column++;
        }
        if (!empty($total_money) && !empty($total_name))
        {
            $objActSheet->setCellValue('A'.$column, $total_name);
            $objActSheet->setCellValue('B'.$column, $total_money[0]['total_money']);
        }        
        
        header('pragma:public');
        header('Content-type:application/vnd.m