PHP 开发学习[6] —— PHP导出Excel表实例参考

$data = getAllBabyByExcle();
$arr = array(
   array('编号','宝贝姓名','父母姓名','联系方式','性别','年龄(岁)','所在城市','点赞人数','视频链接'),
);
$newArr=array();
foreach ($data as $k=>$v){
   $newArr[$k]=$data[$k];
}
$arr[0]=array_merge($arr,$newArr);
$TextArr = array();
$time=time();
$file = fopen("./excl/babysExcl".$time.".xls","a+");

$data1="excl/babysExcl".$time.".xls";
foreach($arr as $r){
   foreach($r as $v){
      fwrite($file,implode("\t", $v)."\n");
   }
}
fclose($file);
header("Content-type: applicationnd.ms-excel");
header("Location: ".$data1);