在chrome中3000多项导出到excel的问题

Question

function SaveContents(element, filename) {
if (window.Blob && window.navigator.msSaveOrOpenBlob) {
    var blob = new Blob([element], {
        type: 'data:application/vnd.ms-excel'
    });
    window.navigator.msSaveBlob(blob, filename + '.xls');
} else {
    var a = document.createElement('a');
    document.body.appendChild(a);
    a.href = 'data:application/vnd.ms-excel;charset=utf-8,%EF%BB%BF' + encodeURIComponent(element);
    a.download = filename + ".xls";
    a.click();
}}

Answer 1

你不应该再这样做了。很久以前，增加了两件事：

> 开始下载目标的的

下载属性。示例：

<a href="myfile.png" download="image.png">Download image</a>

URL.createobjecturl，它将blob转换为虚拟URL，可以将其视为internet上的文件，请尝试以下操作，例如：

// convert letters to bytes
const letters = new Uint8Array([..."Hello world"].map((x)=>x.charCodeAt(0)));
const blob = new Blob([letters], {type:"text/plain"});
// Try to open the result in new tab
console.log(URL.createObjectURL(blob));
// remember to clear the URL later using URL.revokeObjectURL

var a = document.createElement('a');
document.body.appendChild(a);
var blob = new Blob([element], {
    type: 'data:application/vnd.ms-excel'
});
a.href = URL.createObjectURL(blob);
a.download = filename + ".xls";
a.click();
// lazy cleanup, note that this renders the link invalid
setTimeout(()=>{URL.revokeObjectURL(a.href);}, 500);