导出CSV,无论是什么格式,excel打卡都是乱码
需要加上
echo "\xEF\xBB\xBF";
header("Content-Disposition:attachment;filename=$fileName.csv");
header("Content-Type:$exportType;charset=UTF-8");
header("Expires: Mon, 31 Dec 2000 00:00:00 GMT" );
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT" );
header("Cache-Control: post-check=0, pre-check=0", false ); $header = implode("\", \"", $headers);
$header = "\"" .$header;
$header .= "\"\r\n";
echo "\xEF\xBB\xBF";
echo $header; foreach($entries as $row) {
foreach ($row as $key => $value) {
/* To support double quotations in CSV format
* To review: http://creativyst.com/Doc/Articles/CSV/CSV01.htm#EmbedBRs
*/
$row[$key] = str_replace('"', '""', $value);
}
$line = implode("\",\"",$row);
$line = "\"" .$line;
$line .= "\"\r\n";
echo $line;
}