php Excel ?? ????

phpExcel ?? ???? http://phpexcel.codeplex.com/

/**
     * 導(dǎo)出特定文件
	 * 根據(jù)具體情況而定
     */
    public function download(){

        //1. 從數(shù)據(jù)庫來獲取對應(yīng)的二維數(shù)組
        $alist = array(...);
        $list = $alist;
        $data = array();
		//2. 設(shè)置xls的 表頭名
        $headArr = array("排名","姓名","手機(jī)","獲獎(jiǎng)","參與時(shí)間");
        if(false === empty($list)){
            $i=0;
            foreach ($list as $key => $val){
                //組裝對應(yīng)的單元格A，B，C，D。。。
				$data[$i] = array(
                       ($i+1),            //A
                       $val['name'],      //B
                       $val['tel'],       //C
                       $val['award'],     //D
                       ...
                    );
                 $i++;
            }
        }else{
            $data[0] = array('暫無相關(guān)記錄！');
        }

        $fileName = "test-excel_";
        $this->explodexls($data,$headArr,$fileName);
    }

    /**
	 * 工具函數(shù) 處理 xls 文件導(dǎo)出
	 * @param $data array() 對應(yīng)的tbody 數(shù)據(jù)
     * @param $headArr array() 對應(yīng)的thead 數(shù)據(jù)
	 * @param $fileName string  指定的導(dǎo)出文件名 
	 * @return xls格式 文件自動(dòng)導(dǎo)出
     */
    public function explodexls($data,$headArr,$fileName){
		//注意這里換成對應(yīng)的根目錄 找到絕對路徑
        $dir = __dir__.'/../../../../public';
        require_once $dir.'/excel/PHPExcel.php';
        require_once $dir.'/excel/PHPExcel/Writer/Excel2007.php';
        require_once $dir.'/excel/PHPExcel/Writer/Excel5.php';
        include_once $dir.'/excel/PHPExcel/IOFactory.php';

        if(empty($data) || !is_array($data)){
            die("data must be a array");
        }
        if(empty($fileName)){
            exit;
        }
        $date = date("Y_m_d",time());
        $fileName .= "_{$date}.xls";
        //創(chuàng)建新的PHPExcel對象
        $objPHPExcel = new PHPExcel();
        $objProps = $objPHPExcel->getProperties();
        //設(shè)置表頭
        $key = ord("A");
        foreach($headArr as $v){
            $colum = chr($key);
            $objPHPExcel->setActiveSheetIndex(0)->setCellValue($colum.'1', $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('Simple');
        //設(shè)置活動(dòng)單指數(shù)到第一個(gè)表,所以Excel打開這是第一個(gè)表
        $objPHPExcel->setActiveSheetIndex(0);
        //將輸出重定向到一個(gè)客戶端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');
        $objWriter->save('php://output'); //文件通過瀏覽器下載
        exit;
    }

???? PHP Excel ??? ???? ?? phpExcel ?? ?????? ?????, ? ??? PHP ????? ??? ?? ????? ??? ??? ????.