php导出excel

最新推荐文章于 2024-07-16 08:10:25 发布

影天

最新推荐文章于 2024-07-16 08:10:25 发布

阅读量531

点赞数

分类专栏： php

本文链接：https://blog.csdn.net/xwlyun/article/details/43793949

版权

php 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

<?php

$data = array(
	array('name'=>'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);
	}
}