set character set utf8 on download xls php code example
Example 1: excel utf-8 php
header('Content-Encoding: UTF-8');
header("Content-type: application/x-msexcel; charset=utf-8");
fputs ($fp, "\xEF\xBB\xBF");
header('Content-Encoding: UTF-8');
header("Content-type: application/x-msexcel; charset=utf-8");
header('Content-Disposition: attachment; filename="'.$fileName.'.csv"');
header('Cache-Control: max-age=0');
$fp = fopen('php://output', 'a');
fputs ($fp, "\xEF\xBB\xBF");
foreach ($headlist as $key => $value) {
$headlist[$key] = $value;
}
fputcsv($fp, $headlist);
Example 2: csv utf-8 excel into php
chr(255) . chr(254)