原生js调用后端接口form表单导出Excel函数:
function exportExcel(url, params) { //url是接口请求地址, params是get请求需要的参数
let form = document.createElement("form");
form.action = url;
form.method = "get";
form.target = "_blank";
form.acceptCharset = "utf-8";
document.body.appendChild(form);
for(let key in params){
let input = document.createElement("input");
input.type = "hidden";
input.name = key;
input.value = params[key];
form.appendChild(input);
}
form.submit();
form.removeChild(form);
};
导出函数的调用:
<div id="main">
<button id="btn">下载Excel</button>
</div>
<script>
btn.onclick = function() {
let params = {
suject: '数学'
score: 90
};
exortExcel(params, ".../toExportFile");
}
</script>