js 将表格导出csv格式

function exportTableToCSV(filename) {
    var csv = [];
    var rows = document.querySelectorAll("table tr");
    
    for (var i = 0; i < rows.length; i++) {
        var row = [], cols = rows[i].querySelectorAll("td, th");
        
        for (var j = 0; j < cols.length; j++) 
            row.push(cols[j].innerText);
        
        csv.push(row.join(",")); // 使用逗号分隔
    }
    
    // 将CSV内容转换为Blob对象
    var csvFile = new Blob([csv.join("\n")], {type: "text/csv;charset=utf-8;"});
    
    // 创建下载链接
    var downloadLink = document.createElement("a");
    downloadLink.download = filename;
    downloadLink.href = window.URL.createObjectURL(csvFile);
    downloadLink.style.display = "none";
    document.body.appendChild(downloadLink);
    downloadLink.click();
    document.body.removeChild(downloadLink);
}

// 使用方法
document.getElementById("exportButton").addEventListener("click", function() {
    exportTableToCSV("table.csv");
});

row.push('"' + cols[j].innerText.replace(/"/g, '""') + '"');