/*整理导出Excel开始*/
/**
* @creator Six
* @data 2018/11/22
* @desc 数据导出到Excel文件
* @param $dataSix 需要导出的数据主体
* @param $tableSix Excel文件主体
*/
public function exportSix(){
// header('Content-Type: text/html; charset=utf-8');/*若预览数据时编码错误请把此项解除注释*/
// $innerdata=M('product')->where('status=1')->select();/*从数据库查询,按需自定义即可*/
/*以下为模拟SQL查询的数据*/
$dataSix=array(
array('name'=>'张三','sex'=>'男','age'=>'18','score'=>'100'),
array('name'=>'李四','sex'=>'女','age'=>'19','score'=>'98'),
array('name'=>'王五','sex'=>'男','age'=>'18','score'=>'100'),
array('name'=>'赵六','sex'=>'男','age'=>'16','score'=>'66'),
);
// var_dump($dataSix);exit;/*需要预览数据时请把此项解除注释*/
/*以下为拼接的导出Excel的格式和内容,如需要进一步美化,添加H5属性或自定义css样式即可*/
$tableSix = '';
$tableSix .= "
<table border='1'>
<thead>
<tr>
<th>姓名</th>
<th>性别</th>
<th>年龄</th>
<th>成绩 </th>
</tr>
</thead>
<tbody>";
foreach ($dataSix as $six) {
$tableSix .= "
<tr>
<td>{$six['name']}</td>
<td>{$six['sex']}</td>
<td>{$six['age']}</td>
<td>{$six['score']}</td>
</tr>";
}
$tableSix .= "</tbody></table>";
/*通过header头控制输出excel表格*/
header("Pragma: public");
header("Expires: 0");
header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");;
header('Content-Disposition:attachment;filename="成绩表.xls"');/*此处为表名,按需自定义*/
header("Content-Transfer-Encoding:binary");
echo $tableSix;
}
/*整理导出Excel结束*/
欢迎交流与指教 :)