js数据导出到csv

function exportToCSV(data, filename) {
    // 将数据转换为 CSV 格式
    const csvContent = data.map(row => row.join(",")).join("\n");

    // 创建一个 Blob 对象
    const blob = new Blob([csvContent], { type: "text/csv;charset=utf-8;" });

    // 创建一个下载链接
    const link = document.createElement("a");
    const url = URL.createObjectURL(blob);
    link.setAttribute("href", url);
    link.setAttribute("download", filename + ".csv");
    link.style.visibility = "hidden";
    document.body.appendChild(link);

    // 模拟点击链接进行下载
    link.click();

    // 清理
    document.body.removeChild(link);
}

// 示例数据
const data = [
    ["Name", "Age", "Email"],
    ["John Doe", "30", "john@example.com"],
    ["Jane Smith", "25", "jane@example.com"]
];

// 导出 CSV 文件
exportToCSV(data, "example");

function escapeCSVField(field) {
    if (typeof field === "string") {
        field = field.replace(/"/g, '""'); // 替换双引号为两个双引号
        if (field.includes(",") || field.includes("\n") || field.includes("\"")) {
            field = `"${field}"`; // 用双引号括起来
        }
    }
    return field;
}

function exportToCSV(data, filename) {
    const csvContent = data.map(row => row.map(escapeCSVField).join(",")).join("\n");
    // 其余代码不变
}

function exportToCSV(data, filename) {
    const csvContent = data.map(row => row.map(escapeCSVField).join(",")).join("\n");
    const blob = new Blob([csvContent], { type: "text/csv;charset=utf-8;" });

    if (navigator.msSaveBlob) { // IE 10+
        navigator.msSaveBlob(blob, filename + ".csv");
    } else {
        const link = document.createElement("a");
        const url = URL.createObjectURL(blob);
        link.setAttribute("href", url);
        link.setAttribute("download", filename + ".csv");
        link.style.visibility = "hidden";
        document.body.appendChild(link);
        link.click();
        document.body.removeChild(link);
    }
}