首页 > 教程 >
dede织梦后台增加php导出到excel功能不出现乱码
2023-03-10教程围观次
简介dede织梦系统怎样导出后台的文章或自定义模型中的数据到excel，并且不出现乱码在后台目录创建一个php文件toexcel.php,在最上面加入代码；require_once(dirname(__FILE__).'/config.php');require_once(DEDEINC.'/typelink.class.php');require_once(DEDEINC.'/datalistcp.
在后台目录创建一个php文件toexcel.php,在最上面加入代码；
require_once(dirname(__FILE__).'/config.php');
require_once(DEDEINC.'/type .class.php');
require_once(DEDEINC.'/datalistcp.class.php');
require_once(DEDEADMIN.'/inc/inc_list_functions.php');
加入导出到excel类；
class Excel
{
private $head;
private $body;
public function addHeader($arr){
foreach($arr as $headVal){
$headVal = $this->charset($headVal);
$this->head .= "{$headVal} ";
}
$this->head .= " ";
}
public function addBody($arr){
foreach($arr as $arrBody){
foreach($arrBody as $bodyVal){
$bodyVal = $this->charset($bodyVal);
$this->body .= "{$bodyVal} ";
}
$this->body .= " ";
}
}
public function downLoad($filename=''){
if(!$filename)
$filename = date('YmdHis',time()).'.xls';
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=$filename");
header("Content-Type:charset=gb2312");
if($this->head)
echo $this->head;
echo $this->body;
}
public function charset($string){
return mb_convert_encoding($string,'GBK','auto');
}
}
代码解释：
1.输出列名数组，并转码
public function addHeader($arr){
foreach($arr as $headVal){
$headVal = $this->charset($headVal);
$this->head .= "{$headVal} ";
}
$this->head .= " ";
}
2.输出导出内容数组，并转码
public function addBody($arr){
foreach($arr as $arrBody){
foreach($arrBody as $bodyVal){
$bodyVal = $this->charset($bodyVal);
$this->body .= "{$bodyVal} ";
}
$this->body .= " ";
}
}
下载链接：网站源码/小程序源码/网站模板下载
