PHP 设置 HTTP 头信息导出 Excel 报表

编程记录 · 2018-12-25

不需要用到 fputcsv 函数来生成报表。只需设置相应的格式和HTTP头信息,就能够生成报表了。附上代码:

header("Content-type: application/vnd.ms-excel; charset=utf-8");
header("Content-Disposition: attachment; filename=excel.xls");

$data = "分类销售统计\t\n";
$data .= "排名\t产品大类\t销售额(万)\t销售占比\t单品数量\n";

if (EC_CHARSET == 'utf-8')
{

  echo ecs_iconv(EC_CHARSET, 'GB2312', $data);

}
else
{

  echo $data;

}
?>

Theme Jasmine by Kent Liao
辽ICP备2021009421号-2