欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

php_excel / output.php

程序员文章站 2022-05-17 14:26:11
...
'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);	}}