public function msg(){
//$list为库中查出的数据
$voList = array();
foreach ($list as $k => $v){
$voList[] = array(1,'张三','13111111111',date('Y-m-d H:i:s'));
}
//表头
$tableheader = array('用户ID','用户名','手机号','时间');
//导出的名称
$fileName = '测试名称' . time();
$this->getExcel($fileName, $tableheader, $voList);
}
/**
* 简单导出excel代码
* @param string $fileName 文件名称
* @param array $headArr 表头信息
* @param array $data 要导出的值
*/
public function getExcel($fileName,$headArr,$data){
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");
array_unshift($data,$headArr);
foreach($data as $key => $val){
$data[$key]=implode("\t", $data[$key]);
}
echo iconv('utf-8','gbk',implode("\n",$data));
}
简单PHP导出Excel
最新推荐文章于 2022-11-11 11:28:20 发布