php如何生成excel表格
PHP下载生成表格的需求经常会使用到，代码可以一次性封装，以方便后续使用。
//exlcel表格下载函数
function down_xls($data, $keynames,$oneway, $name='dataxls') {
$xls[] = "<html><meta http-equiv=content-type content=\"text/html; charset=UTF-8\"><body><table border='1'>";
$xls[] = "<tr><td>ID</td><td>" . implode("</td><td>", array_values($keynames)) . '</td></tr>';
foreach($data As $o) {
$line = array(++$index);
foreach($keynames AS $k=>$v) {
$line[] = $o[$k];
}
$xls[] = '<tr><td>'. implode("</td><td>", $line) . '</td></tr>';
}
if($oneway) $xls[] = '<tr><td colspan="'.count($line).'" align="center">'.$oneway.'</td></tr>';
$xls[] = '</table></body></html>';
$xls = join("\r\n", $xls);
header('Content-Disposition: attachment; filename="'.$name.'.xls"');
die(mb_convert_encoding($xls,'UTF-8','UTF-8'));
}