PHPEXCEL生成excel文件_phpexcel类生成excel文件-优快云博客

<?php

/**

 *
 PHPEXCEL生成excel文件

 *
 @author:firmy

 *
 @desc 支持任意行列数据生成excel文件，暂未添加单元格样式和对齐

 */

require_once'library/PHPExcel.php';

require_once'library/PHPExcel/Reader/Excel2007.php';

require_once'library/PHPExcel/Reader/Excel5.php';

include_once'library/PHPExcel/IOFactory.php';

$fileName=
"test_excel";

$headArr=
array("第一列","第二列","第三列");

$data=
array(array(1,2),array(1,3),array(5,7));

getExcel($fileName,$headArr,$data);

functiongetExcel($fileName,$headArr,$data){

    if(empty($data)
 || !is_array($data)){

        die("data
 must be a array");

    }

    if(empty($fileName)){

        exit;

    }

    $date=
date("Y_m_d",time());

    $fileName.=
"_{$date}.xlsx";

    //创建新的PHPExcel对象

    $objPHPExcel=
newPHPExcel();

    $objProps=
$objPHPExcel->getProperties();

    //设置表头

    $key=
 ord("A");

    foreach($headArras

$v){

        $colum=
chr($key);

        $objPHPExcel->setActiveSheetIndex(0)
 ->setCellValue($colum.'1',$v);

        $key+=
 1;

    }

    $column=
 2;

    $objActSheet=
$objPHPExcel->getActiveSheet();

    foreach($dataas

$key 
=> $rows){//行写入

        $span=
 ord("A");

        foreach($rowsas

$keyName=>$value){//
 列写入

            $j=
chr($span);

            $objActSheet->setCellValue($j.$column,$value);

            $span++;

        }

        $column++;

    }

    $fileName=
 iconv("utf-8","gb2312",$fileName);

    //重命名表

    $objPHPExcel->getActiveSheet()->setTitle('Simple');

    //设置活动单指数到第一个表,所以Excel打开这是第一个表

    $objPHPExcel->setActiveSheetIndex(0);

    //将输出重定向到一个客户端web浏览器(Excel2007)

          header('Content-Type:
 application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');

          header("Content-Disposition:
 attachment; filename=\"$fileName\"");

          header('Cache-Control:
 max-age=0');

          $objWriter=
 PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel2007');

          if(!empty($_GET['excel'])){

            $objWriter->save('php://output');
 //文件通过浏览器下载

        }else{

          $objWriter->save($fileName);//脚本方式运行，保存在当前目录

        }

  exit;

}