PHP使用ajax的post方式下载excel文件
ob_start();
$objWriter->save('php://output');
$xlsData = ob_get_contents();
ob_end_clean();
 return ['filename' => $filename, 'file' => "data:application/vnd.ms-excel;base64," . base64_encode($xlsData)];
前端:
$.ajax({
        type:'POST',
        url: '/crm/customer/excelout',
        data: {customer_id:delItem},
        beforeSend: function(request) {
            request.setRequestHeader("Authorization", "token信息,验证身份");
        },
        success: function(redata) {
            // 创建a标签,设置属性,并触发点击下载
            var $a = $("<a>");
            $a.attr("href", redata.data.file);
            $a.attr("download", redata.data.filename);
            $("body").append($a);
            $a[0].click();
            $a.remove();
        }
    });