php将数据用excel文件格式导出

 

创建文件

// $filename=$address.'_'.$query.'_'.$distance."千米.xls";//先定义一个excel文件
// header("Content-Type: application/vnd.ms-excel; charset=utf-8");
// header("Content-Disposition: attachment; filename=$filename");
// header("Pragma: no-cache"); header("Expires: 0");
// //我们先在excel输出表头，当然这不是必须的
// echo iconv("utf-8", "gb2312", "店铺名称")."\t";
// echo iconv("utf-8", "gb2312", "联系电话")."\t";
// echo iconv("utf-8", "gb2312", "百度上的连接")."\t";
// echo iconv("utf-8", "gb2312", "店铺地址")."\n";//注意这个要换行

导出文件

// echo iconv("utf-8", "gb2312", $result[$jj]->name)."\t";
// echo iconv("utf-8", "gb2312", $result[$jj]->telephone)."\t";
// echo iconv("utf-8", "gb2312", $result[$jj]->province.$result[$jj]->city.$result[$jj]->area.$result[$jj]->address)."\t";
// echo iconv("utf-8", "gb2312", $result[$jj]->detail_info->detail_url)."\n";