excel导出功能（小工具-导出excel）

我们一起去了解并探讨一下这个问题吧!

excel导出功能?function downExcel($data){$fileName = 'lottery' . date('YmdH') . '.xls';header("Content-type:application/vnd.ms-excel");header("Content-Disposition:attachment;filename=" . $fileName);header('Cache-Control: max-age=0');$tab = "\t";$br = "\n";$head = "编号" . $tab . "奖品" . $tab . "姓名" . $tab . "电话" . $tab . "地址" . $tab . "中奖日期";$head = iconv("UTF-8", "gb2312//IGNORE", $head);//输出内容如下：echo $head . $br;foreach ($data as $key => $value) {echo ($key1) . $tab;foreach ($value as $kk => $mn) {if (in_array($kk, ['name', 'prize_name', 'address'])) {$mn = iconv("UTF-8", "gbk//IGNORE", $mn);$mn = str_replace("\n", "", $mn);echo $mn . $tab;} elseif ($kk == 'phone' || $kk == 'create_time') {$mn = "=\"{$mn}\"";//原样输出需要处理echo $mn . $tab;}}echo $br;}exit;}使用这种html方式导出不会出现莫名的乱码现象，下面我们就来说一说关于excel导出功能?我们一起去了解并探讨一下这个问题吧!

excel导出功能

function downExcel($data){$fileName = 'lottery' . date('YmdH') . '.xls';header("Content-type:application/vnd.ms-excel");header("Content-Disposition:attachment;filename=" . $fileName);header('Cache-Control: max-age=0');$tab = "\t";$br = "\n";$head = "编号" . $tab . "奖品" . $tab . "姓名" . $tab . "电话" . $tab . "地址" . $tab . "中奖日期";$head = iconv("UTF-8", "gb2312//IGNORE", $head);//输出内容如下：echo $head . $br;foreach ($data as $key => $value) {echo ($key1) . $tab;foreach ($value as $kk => $mn) {if (in_array($kk, ['name', 'prize_name', 'address'])) {$mn = iconv("UTF-8", "gbk//IGNORE", $mn);$mn = str_replace("\n", "", $mn);echo $mn . $tab;} elseif ($kk == 'phone' || $kk == 'create_time') {$mn = "=\"{$mn}\"";//原样输出需要处理echo $mn . $tab;}}echo $br;}exit;}使用这种html方式导出不会出现莫名的乱码现象