//导出excel
public function dataToExcel($filename, $data, $header, $keys)
{
$html = $this->dataToHtml($data, $header, $keys);
return $this->htmlToExcel($filename, $html);
}
public function dataToHtml($data, $header, $keys)
{
$str = "<html><head><meta charset=\"utf-8\"></head><body>";
$str .= "<table border=\"1\"><tr>";
foreach ($header as $v) {
$str .= "<th>{$v}</th>";
}
$str .= "</tr>";
foreach ($data as $row) {
$str .= "<tr>";
foreach ($keys as $v) {
$str .= "<td>{$row[$v]}</td>";
}
$str .= "</tr>";
}
$str .= "</table><body></html>";
return $str;
}
public function htmlToExcel($filename, $html)
{
header("Content-Type: application/vnd.ms-excel;charset=utf-8; name='excel'");
// header('Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
// header( "Content-type: application/octet-stream" );
header("Content-Disposition: attachment; filename=" . $filename . '.xls');
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Pragma: no-cache");
header("Expires: 0");
exit($html);
}
