php table如何转excel

\r\n\r\n\r\n
\r\n";
    $str .= "" . $titlename . "
";
    $str .= $title;
    foreach ($datas as $key => $rt) {
        $str .= "";
        foreach ($rt as $k => $v) {
            $str .= "";
        }
        $str .= "\n";
    }
    $str .= "

{$v}
";
    echo $str;
    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);
}
 
 
$dataResult = array(array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11), array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11));
$headTitle = "XX保险公司 优惠券赠送记录";
$title = "优惠券记录";
$headtitle = "{$headTitle}";
$titlename = "
               合作商户
               会员卡号
               车主姓名
               手机号
               车牌号
               优惠券类型
               优惠券名称
               优惠券面值
               优惠券数量
               赠送时间
               截至有效期
           ";
$filename = $title . ".xls";
excelData($dataResult, $titlename, $headtitle, $filename);
echo 'success';