//先获取某个数据
$date = input();
$id = @$date['data'];
$dataResult=Db::table('demo')
->where('id','in',$id)
->select();
// $dataResult = input('data');
// $dataResult = json_decode($dataResult,true);
// dump($dataResult);die;
$headTitle = "XX数据";
$title = date("Y-m-d")."-"."XX数据导出数据";
// $headtitle = "<tr style='height:50px;border-style:none;><td border=\"0\" style='height:60px;width:270px;font-size:22px;' colspan='11'>{$headTitle}</th></tr>";
$headtitle = "<tr style='height:50px;border-style: none;><td border=\"0\" style='height: 60px;width:270px;font-size=22px;' colspan='11'>{$headTitle}</th></tr>";
$titlename="<tr>
<td>编号</td>
<td>XX标题</td>
<td>姓名</td>
<td>年龄</td>
<td>性别</td>
<td>XX号</td>
<td>XX室</td>
<td>XX区</td>
<td>XX志</td>
<td>XX时间</td>
<td>XX操作</td>
<td>XX备注</td>
<td>XX修改</td>
<td>XX时间</td>
<td>XX类型</td>
<td>XX标识</td>
</tr>";
$filename = $title.".xls";
// dump($title);
$this->excelData($dataResult,$titlename,$headtitle,$filename);
public function excelData($datas,$titlename,$title,$filename)
{
$str = "<html xmlns:o=\"urn:schemas-microsoft-com:office:office\"\r\nxmlns:x=\"urn:schemas-microsoft-com:office:excel\"\r\nxmlns=\"http://www.w3.org/TR/REC-html40 \">\r\n<head>\r\n<meta http-equiv=Content-Type content=\"text/
html;charset=utf-8\">\r\n</head>\r\n<body>";
$str .="<table border=1>".$titlename;
$str .= '';
foreach ($datas as $key=> $rt )
{
$str .= "<tr>";
$str .= "<td>{$rt['id']}</td>";
$str .= "<td>{$rt['title']}</td>";
$str .= "<td>{$rt['user']}</td>";
$str .= "<td>{$rt['age']}</td>";
$str .= "<td>{$rt['sex']}</td>";
$str .= "<td>{$rt['num']}</td>";
$str .= "<td>{$rt['department']}</td>";
$str .= "<td>{$rt['lesion']}</td>";
$str .= "<td>{$rt['file']}</td>";
$str .= "<td>{$rt['time']}</td>";
$str .= "<td>{$rt['status']}</td>";
$str .= "<td>{$rt['content']}</td>";
$str .= "<td>{$rt['modify']}</td>";
$str .= "<td>{$rt['chtime']}</td>";
$str .= "<td>{$rt['insurance']}</td>";
$str .= "<td>{$rt['modify']}</td>";
$str .= "</tr>\n";
}
$str .= "</table></body></html>";
header( "Content-type:application/vnd.ms-excel;name='excel'");
header( "Content-type: application/octet-stream" );
header( "Content-Disposition: attachment; filename=".$filename );
header( "Cache-Control: must-revalidate, post-check=0, pre-check=0" );
header( "Pragma: no-cache" );
header( "Expires: 0" );
exit( $str );
}
这种方法可快速导出数据 不需要加载第三方phpExcel类库,线下测试环境php5.5可以 如果线上环境是php7.0建议使用phpexcel类库1.81,php7.0有点问题 不太建议我这个写法。