直接上代码就行了:
- //默认保存的文件名,我电脑装的是 wps,所以写的 xlsx 后缀名,可以更换的
- $filename = 'bengbeng_' . date('Ymd') . '.xlsx';
- header("Content-type:application/vnd.ms-excel;charset:utf-8;");
- header('Content-Disposition:filename='.$filename);
- header("Pragma: no-cache");
- header("Expires: 0");
- header("Cache-control:must-revalidate,post-check=0,pre-check=0"); // 解决IE不能下载问题。
- //标题
- $thead = "用户名\t角色等级\t\n";
- echo(iconv("UTF-8","GBK//IGNORE",$thead));
- // $res 为数据数组
- foreach($res as $row){
- echo(iconv("UTF-8","GBK//IGNORE",$row['accname'] . "\t"));
- echo(iconv("UTF-8","GBK//IGNORE",$row['level'] . "\t\n"));
- }