简单的生成excel文件
$arr_list = array(); //数据库读取, 获取要输出到EXCEL的数组 header('Content-type: application/vnd.ms-excel;'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Content-Disposition: attachment; filename=activity.xls'); //filename:文件名 ob_start(); //打开缓存区 include 'file.html'; //输出内容到缓存区 $output = mb_convert_encoding(ob_get_clean(), 'GBK', 'UTF-8'); //缓存区取出,转换编码 echo $output; //输出 <?php echo implode("t", array_keys($arr_list[0])),"n"; foreach($arr_list as $value){ echo implode("t", $value),"n"; } ?>
全网最新最细最实用WPS零基础入门到精通全套教程!带你真正掌握WPS办公! 内含Excel基础操作、函数设计、数据透视表等
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号