'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); }}