本人项目中遇到需求:导出有带格式的excel文件方便打印,参考了文章:http://www.thinkphp.cn/code/2277.html
单独建立一个视图文件printexcel.html,代码如下:
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<volist name="data" id="vo">
<div>
<ul style="border-bottom: 1px dotted #ccc">送水信息--送水:{xxx}
<li>电话: {xxx}</li>
<li>地址: {xxx}</li>
<li>收款: <switch name="xxx">
<case value="1">现金</case>
<case value="2">微信</case>
<default />支付宝
</switch><if condition="xxx gt 0">已付<else />应收</if>
</li>
<li>下单时间:{xxx|date="Y-m-d H:i:s",###}</li>
<li>名称: {xxx}</li>
<li>规格: {xxx}</li>
<li>数量: {xxx}</li>
</ul>
</div>
</volist>
</body>
</html>
在对应的控制器中添加方法printexcel,代码如下:
public function printexcel(){
$orderid=$_GET['Fid']; //点击导出时要传的一个或几个id,(用到号分割的字符串)
$pfname="订单".date("Y-m-d H:m:s",time());
$pfsuffix="xls";
header("Content-Type: application/vnd.ms-excel;name='excel'");
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=$pfname.$pfsuffix");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type:application/download");
header("Pragma: no-cache");
header("Expires:0");
//业务数据
$data=M()->table('order as o')->field('o.*,g.xxx,w.xxx')->join('ordergood as g on g.oid=o.id')->join('worker as w on w.id=o.wid')->where(array('o.id'=>array('in', split(',', $orderid))))->select();
$this->assign('data',$data);
$this->display();
}
这样点击按钮href=本方法路径,就可以导出带有格式的excel,但还是会提示文件格式和扩展名不匹配,点击是,excel表就有了。