PHP中怎么把mysql查处的数据导出成Excel

假设你取出来的数据是这样的
$data[0] => array('id'=>1, 'name'='aaa')
$data[1] => array('id'=>2, 'name'='bbb')
$data[2] => array('id'=>3, 'name'='ccc')

可以这样写：
$output = "";
$output .= "";
$output .= "";
$output .= "";
$output .= "";
$output .= "";
$output .= "";
foreach ($data as $value) {
$output .= "";
}
$output .= "

ID	NAME
{$value['id']}	{$value['name']}

";
$output .= "";
$output .= "";

header("Content-type:application/msexcel");
header("Content-disposition: attachment; filename=output.xls");
header("Cache-control: private");
header("Pragma: private");
print($output);

执行这个php会弹出下载文件对话框，下载下来就是一个伪xls文件

假设你取出来的数据是这样的
$data[0]
=>
array('id'=>1,
'name'='aaa')
$data[1]
=>
array('id'=>2,
'name'='bbb')
$data[2]
=>
array('id'=>3,
'name'='ccc')
可以这样写：
$output
=
"";
$output
.=
"";
$output
.=
"http-equiv=Content-Type
content=\"text/html;
charset=utf-8\">";
$output
.=
"";
$output
.=
"";
$output
.=
"BORDER=1>";
$output
.=
"IDNAME";
foreach
($data
as
$value)
{
$output
.=
"{$value['id']}{$value['name']}";
}
$output
.=
"";
$output
.=
"";
$output
.=
"";
header("Content-type:application/msexcel");
header("Content-disposition:
attachment;
filename=output.xls");
header("Cache-control:
private");
header("Pragma:
private");
print($output);
执行这个php会弹出下载文件对话框，下载下来就是一个伪xls文件