php 把数据导成excel格式

1、php部分

$filename = "标题.xls";

header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=$filename");
header("Content-Transfer-Encoding: binary ");

$this->display('bd/worth/worthrepaywaitlog.export.html');


2、html部分

就是简单的table标签就可以了