查询出的数组，输出excel格式

Excel可以直接打开csv文件…试试

$array = Array (

0 => Array (

0 => “How was the Food?”,

1 => 3,

2 => 4

),

1 => Array (

0 => “How was the first party of the semester?”,

1 => 2,

2 => 4,

3 => 0

)

);

header(“Content-Disposition: attachment; filename=“demo.xls””);

header(“Content-Type: application/vnd.ms-excel;”);

header(“Pragma: no-cache”);

header(“Expires: 0”);

$out = fopen(“php://output”, ‘w’);

foreach ($array as $data)

{

fputcsv($out, $data,"\t");

}

fclose($out);