求一个PHP导出EXCEL数据的代码

Question

可以处理中文，简单好用！谢谢

Answer 1

header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=test1.xls");  
$data = array(
    array("firstname" => "张三", "lastname" => "Johnson", "age" => 25),
    array("firstname" => "Amanda", "lastname" => "Miller", "age" => 18),
    array("firstname" => "James", "lastname" => "Brown", "age" => 31),
    array("firstname" => "Patricia", "lastname" => "Williams", "age" => 7),
    array("firstname" => "Michael", "lastname" => "Davis", "age" => 43),
    array("firstname" => "Sarah", "lastname" => "Miller", "age" => 24),
    array("firstname" => "Patrick", "lastname" => "Miller", "age" => 27)
);
//foreach($data as $row){
//echo "{$row['firstname']},{$row['lastname']},{$row['age']}\n";
//}
echo "AAA\n";
echo "好 的\n";我想放到指定的列可以做到吗? 这个都在第一列

Answer 2

或者TABLE导出到PHP，每个单元格与EXCEL对应，那也可以！！

Answer 3

header("Content-type:application/vnd.ms-excel"); 
header("Content-Disposition:filename=test1.xls"); 
$data = array( 
array("firstname" => "张三", "lastname" => "Johnson", "age" => 25), 
array("firstname" => "Amanda", "lastname" => "Miller", "age" => 18),
array("firstname" => "James", "lastname" => "Brown", "age" => 31),
array("firstname" => "Patricia", "lastname" => "Williams", "age" => 7), 
array("firstname" => "Michael", "lastname" => "Davis", "age" => 43), 
array("firstname" => "Sarah", "lastname" => "Miller", "age" => 24), 
array("firstname" => "Patrick", "lastname" => "Miller", "age" => 27) ); 
echo  "firstname"."\t"."lastname"."\t"."age";
echo "\n";
foreach($data as $row){ 
$tt.=$row['firstname']."\t".$row['lastname']."\t".$row['age']."\n"; 
} 
echo $tt;