导出数据到表格PHP
public function excel(){ $filename = '导出表格'; $header = ['编号','名称']; $index = ['id','name']; $list = array( 0 => array('id' => 1, 'name' => 'fdfs'), 1 => array('id' => 2, 'name' => 'ffdfdsafs'), 2 => array('id' => 3, 'name' => 'fdfgdgsddfafass'), ); header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:filename=".$filename.".xls"); $table_header = rtrim(implode("\t",$header), "\t"); $strexport = $table_header."\r"; foreach ($list as $row){ foreach($index as $val){ $strexport .= $row[$val] . "\t"; } rtrim($strexport,"\t"); $strexport .= "\r"; } $strexport=iconv('UTF-8',"GB2312//IGNORE", $strexport); exit($strexport); }
相关推荐
-
实现缩略图和加水印的php类 php
2019-1-8
-
php微信分享demo php
2019-1-7
-
thinkphp上传图片,生成缩略图 php
2019-1-7
-
php+shell检测文件类型 php
2019-1-8
-
PHP post调接口代码 php
2019-1-7
-
php验证码 php
2019-1-7
-
Thinkphp5封装上传图片 php
2019-1-7
-
8个新鲜的PHP常用代码 php
2019-1-8
-
yii常用操作数据 php
2019-1-7
-
PHP简单 对象(object) 与 数组(array) 的转换 php
2019-1-7