ajax+PHPExcel 下载Excel（ajax导出excel）

HTML

return [ '<a href = "#" onClick = "trk_detail(\'' + q_mth + '\',\'' + q_slic + '\',\'' + q_type + '\')">' + ttlpcs + '</a>'].join("")

jquery

    function trk_detail(q_mth, q_slic, q_type) {
        var url = 'json/diad_pu_trk_download.php';
        var params = {
            q_year: q_mth,
            q_slic: q_slic,
            q_type: q_type
        };
        $.ajax({
            type: 'GET',
            url: url,
            data: params,
            dataType: 'json',
            // beforeSend: function (request) {
            //     request.setRequestHeader("Authorization", "token信息，验证身份");
            // },
            success: function (data) {
                console.log(data)
                var $a = $("<a>");
                $a.attr("href", data.file);
                $("body").append($a);
                $a.attr("download", data.filename);
                $a[0].click();
                $a.remove();
            }
        });
    }

PHP

$filename="DIAD_".$type."_".$slic.".xlsx";
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
ob_start();
$objWriter->save('php://output'); //输出到浏览器
$xlsData = ob_get_contents();
ob_end_clean();
$response =  array(
	'filename' => $filename,
	'file' => "data:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;base64," . base64_encode($xlsData)
);
die(json_encode($response));