由于要兼容 iOS 和 Android 的关系,所以移动端的 excel 下载得后端生成文件并给到移动端静态文件地址,让移动端能够跳转下载再预览。
这里给出前端 js demo 代码:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" /> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <title>Document</title> </head> <body> <button onclick="download('https://workwxconnect.test.upchina.com/files/2022-12-22/2022122209351768.xls')" > 下载 </button> <script src="https://cdn.jsdelivr.net/npm/axios/dist/axios.min.js"></script> <script> function download(url, params = {}) { let tempForm = document.createElement("form"); tempForm.action = url; tempForm.method = "get"; tempForm.style.display = "none"; for (var x in params) { let opt = document.createElement("textarea"); opt.name = x; opt.value = params[x]; tempForm.appendChild(opt); } document.body.appendChild(tempForm); tempForm.submit(); return tempForm; } </script> </body> </html>
|