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));
最新评论