PHP生成excel，方法一:header生成_php header excel-CSDN博客

public function export_order()
    {
    //搜索条件
$where = 'where 1=1 ';
$consignee = I('consignee');
if($consignee){
$where .= " AND consignee like '%$consignee%' ";
}
$order_sn =  I('order_sn');
if($order_sn){
$where .= " AND order_sn = '$order_sn' ";
}
if(I('order_status')){
$where .= " AND order_status = ".I('order_status');
}

$timegap = I('timegap');
if($timegap){
$gap = explode('-', $timegap);
$begin = strtotime($gap[0]);
$end = strtotime($gap[1]);
$where .= " AND add_time>$begin and add_time<$end ";
}

$sql = "select *,FROM_UNIXTIME(add_time,'%Y-%m-%d') as create_time from __PREFIX__order $where order by order_id";
    $orderList = D()->query($sql);
    $strTable ='<table width="500" border="1">';
    $strTable .= '<tr>';
    $strTable .= '<td style="text-align:center;font-size:12px;width:120px;">订单编号</td>';
    $strTable .= '<td style="text-align:center;font-size:12px;" width="100">日期</td>';
    $strTable .= '<td style="text-align:center;font-size:12px;" width="*">收货人</td>';
    $strTable .= '<td style="text-align:center;font-size:12px;" width="*">收货地址</td>';
    $strTable .= '<td style="text-align:center;font-size:12px;" width="*">电话</td>';
    $strTable .= '<td style="text-align:center;font-size:12px;" width="*">订单金额</td>';
    $strTable .= '<td style="text-align:center;font-size:12px;" width="*">实际支付</td>';
    $strTable .= '<td style="text-align:center;font-size:12px;" width="*">支付方式</td>';
    $strTable .= '<td style="text-align:center;font-size:12px;" width="*">支付状态</td>';
    $strTable .= '<td style="text-align:center;font-size:12px;" width="*">发货状态</td>';
    $strTable .= '<td style="text-align:center;font-size:12px;" width="*">商品信息</td>';
    $strTable .= '</tr>';
    if(is_array($orderList)){
    $region   = M('region')->getField('id,name');
    foreach($orderList as $k=>$val){
    $strTable .= '<tr>';
    $strTable .= '<td style="text-align:center;font-size:12px;"> '.$val['order_sn'].'</td>';
    $strTable .= '<td style="text-align:left;font-size:12px;">'.$val['create_time'].' </td>';
    $strTable .= '<td style="text-align:left;font-size:12px;">'.$val['consignee'].'</td>';
                        $strTable .= '<td style="text-align:left;font-size:12px;">'."{$region[$val['province']]},{$region[$val['city']]},{$region[$val['district']]},{$region[$val['twon']]}{$val['address']}".' </td>';
    $strTable .= '<td style="text-align:left;font-size:12px;">'.$val['mobile'].'</td>';
    $strTable .= '<td style="text-align:left;font-size:12px;">'.$val['goods_price'].'</td>';
    $strTable .= '<td style="text-align:left;font-size:12px;">'.$val['order_amount'].'</td>';
    $strTable .= '<td style="text-align:left;font-size:12px;">'.$val['pay_name'].'</td>';
    $strTable .= '<td style="text-align:left;font-size:12px;">'.$this->pay_status[$val['pay_status']].'</td>';
    $strTable .= '<td style="text-align:left;font-size:12px;">'.$this->shipping_status[$val['shipping_status']].'</td>';
    $orderGoods = D('order_goods')->where('order_id='.$val['order_id'])->select();
    $strGoods="";
    foreach($orderGoods as $goods){
    $strGoods .= "商品编号：".$goods['goods_sn']." 商品名称：".$goods['goods_name'];
    if ($goods['spec_key_name'] != '') $strGoods .= " 规格：".$goods['spec_key_name'];
    $strGoods .= "<br />";
    }
    unset($orderGoods);
    $strTable .= '<td style="text-align:left;font-size:12px;">'.$strGoods.' </td>';
    $strTable .= '</tr>';
    }
    }
    $strTable .='</table>';
    unset($orderList);
    downloadExcel($strTable,'order');
    exit();
    }

/**
* 导出excel
* @param $strTable 表格内容
* @param $filename 文件名
*/
function downloadExcel($strTable,$filename)
{
header("Content-type: application/vnd.ms-excel");
header("Content-Type: application/force-download");
header("Content-Disposition: attachment; filename=".$filename."_".date('Y-m-d').".xls");
header('Expires:0');
header('Pragma:public');
echo '<html><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />'.$strTable.'</html>