php导出excel乱码
 

header("Content-type: application/vnd.ms-excel;");
02.header("Content-Disposition:filename=test.xls");
03.
04.$datas = array(
05. array('id'=>2,'email'=>'aa@aa.com','name'=>'aa'),
06. array('id'=>4,'email'=>'aa@aa.com','name'=>'的决定咖啡店'),
07. array('id'=>5,'email'=>'aa@aa.com','name'=>'CC'),
08. array('id'=>7,'email'=>'aa@aa.com','name'=>'打开附件的客服金额看风景'),
09. array('id'=>9,'email'=>'aa@aa.com','name'=>'ss')
10. );
11.$table = "<table border='1'>";
12.$table .= "<tr>";
13.$table .= "<td>id</td><td>email</td><td>name</td>";
14.$table .= "</tr>";
15.foreach($datas as $key=>$value)
16.{
17.$table .= "<tr>";
18.$table .= "<td>".$value["id"]."</td>";
19.$table .= "<td>".$value["email"]."</td>";
20.$table .= "<td>".iconv("UTF-8", "gb2312",$value["name"])."</td>";
21.$table .= "</tr>";
22.
23.}
24.$table .= "</table>";
25.echo $table;

设置charset也解决不了问题header("Content-type: application/vnd.ms-excel;charset=utf-8");

中文部分用iconv函数转换一下编码
浏览器默认编码是gb2312