excel
作者QQ:67065435 QQ群:821635552
本站内容全部为作者原创,转载请注明出处!
导出csv
- 代码参考
<?php //CSV表格导出(同时去除不可见字符) $result = [ ['姓名', '年龄', '性别'], ['张三', '22', '男'], ['李四', '20', '女'] ]; ob_implicit_flush(1); header("Content-Disposition: attachment;filename=表格导出.csv"); foreach ($result as &$value) { foreach ($value as &$v) { $v = preg_replace('/\s/', '', $v); $v = str_replace('"', '""', $v); $v = '"' . $v . '"'; } $value = implode(',', $value) . "\r\n"; echo $value; } exit;