php导出csv
php导出excel可用PHPExcel插件,也可导出csv,PHPExcel在导出大数据的时候速度不如直接导出csv
php导出csv代码:
set_time_limit(0); $fileName = date('YmdHis', time()); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="' . $fileName . '.csv"'); $fp = fopen('php://output', 'x'); fwrite($fp, chr(0xEF).chr(0xBB).chr(0xBF));//php导出的csv在wps打开是正常的,在officeExcel打开中文是乱码,为防止在officeExcel打开是乱码,要加上这行 foreach ($data as $v){ foreach($v as $key => $item) { $item="\t{$item}"; $row[$key] = $item; } fputcsv($fp, $row); }