分享一个PHP导出到excel的代码,大家在项目可能经常会遇到将数据中的数据导出到excel表格这类需求。
代码
function ExportToExcel($infolist=array(),$columnlist=array(),$filename='excelexport'){ header("Content-type:application/octet-stream"); header("Accept-Ranges:bytes"); header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename=".$filename.".xls"); header("Pragma: no-cache"); header("Expires: 0"); if (!empty($title)){ foreach ($title as $k => $v) { $title[$k]=iconv("utf-8", "gb2312",$v); } $title= implode(" ", $title); echo "$title "; } if (!empty($data)){ foreach($data as $key=>$val){ foreach ($val as $ck => $cv) { $data[$key][$ck]=iconv("UTF-8", "GB2312", $cv); } $data[$key]=implode(" ", $data[$key]); } echo implode(" ",$data); } }
使用方法
//$placeinfo:要导出的数据 //$title:一个一维数组,excel列的名称 //$filename:导出的excel文件的名称 exportexcel($placeinfo,$title,$filename);
彭亚欧个人博客原创文章,转载请注明出处
文章关键词:php导出excel,php导出,excel
文章固定链接:https://www.pengyaou.com/homeart/MTcz.html
上一篇 复旦投毒案嫌犯死刑核准
下一篇 PHPExcel导入与导出