PHPEXCEL生成excel文件-PHP源码

getProperties();
     
    //设置表头
    $key = ord("A");
    foreach($headArr as $v){
        $colum = chr($key);
        $objPHPExcel->setActiveSheetIndex(0) ->setCellValue($colum.&＃39;1&＃39;, $v);
        $key += 1;
    }
     
    $column = 2;
    $objActSheet = $objPHPExcel->getActiveSheet();
    foreach($data as $key => $rows){ //行写入
        $span = ord("A");
        foreach($rows as $keyName=>$value){// 列写入
            $j = chr($span);
            $objActSheet->setCellValue($j.$column, $value);
            $span++;
        }
        $column++;
    }
 
    $fileName = iconv("utf-8", "gb2312", $fileName);
    //重命名表
    $objPHPExcel->getActiveSheet()->setTitle(&＃39;Simple&＃39;);
    //设置活动单指数到第一个表,所以Excel打开这是第一个表
    $objPHPExcel->setActiveSheetIndex(0);
    //将输出重定向到一个客户端web浏览器(Excel2007)
          header(&＃39;Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet&＃39;);
          header("Content-Disposition: attachment; filename=\"$fileName\"");
          header(&＃39;Cache-Control: max-age=0&＃39;);
          $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, &＃39;Excel2007&＃39;);
          if(!empty($_GET[&＃39;excel&＃39;])){
            $objWriter->save(&＃39;php://output&＃39;); //文件通过浏览器下载
        }else{
          $objWriter->save($fileName); //脚本方式运行，保存在当前目录
        }
  exit;
 
}