php_excel / output.php

'Tom','age'=>61,'date'=>'2014-09-24 12:00:00'),array('name'=>'Mark','age'=>25,'date'=>'2014-09-23 11:00:00'),array('name'=>'Lucy','age'=>43,'date'=>'2014-09-22 10:00:00'),);$title = array('姓名','age','時間',);exportexcel($data,$title);die();/** * 匯出excel * @param array $data 資料集 * @param array $title 標題集 * @param string $filename 匯出的excel檔案名稱 */function exportexcel($data=array(),$title=array(),$filename='report'){header("Content-type:application/vnd.ms-excel");header("Content-Disposition:filename=".$filename.".xls");//匯出xls 開始if (!empty($title)){foreach ($title as $k => $v){$title[$k] = iconv("UTF-8", "GBK",$v);}$title = implode("\t", $title);echo "$title\n";}if (!empty($data)){foreach($data as $key=>$val){foreach ($val as $ck => $cv){$data[$key][$ck] = iconv("UTF-8", "GBK", $cv);}$data[$key] = implode("\t", $data[$key]);}echo implode("\n",$data);}}

