PHP Excel导出

phpExcel导出，非常方便快捷

$filename  = '情况.csv';
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename='.$filename);
header('Cache-Control: max-age=0');
$fp = fopen('php://output', 'a');
$head = array('id','时间');
foreach ($head as $i => $v) {
    $head[$i] = iconv('utf-8', 'gbk', $v);
}
fputcsv($fp, $head);
foreach($list as $val) {
    foreach ($val as $i => $v) {
        $val[$i] = iconv('utf-8', 'gbk', $v);
    }
    fputcsv($fp, $val);
}
exit;