使用BOM字符集导出Javascript CSV

function exportCSV(data, filename) {
  var csvContent = "\uFEFF"; // BOM字符集
  var rowDelimiter = "\n";
  var columnDelimiter = ",";

  // 处理数据数组，将其转换为CSV格式的字符串
  data.forEach(function(row) {
    var rowData = row.map(function(value) {
      if (typeof value === 'string') {
        // 处理字段值中的双引号，将其转义为两个双引号
        value = value.replace(/"/g, '""');
        // 如果字段值包含逗号、换行符或双引号，将其用双引号包裹
        if (value.includes(columnDelimiter) || value.includes(rowDelimiter) || value.includes('"')) {
          value = '"' + value + '"';
        }
      }
      return value;
    });
    var rowString = rowData.join(columnDelimiter);
    csvContent += rowString + rowDelimiter;
  });

  // 编码CSV内容字符串
  var encodedCSVContent = encodeURIComponent(csvContent);

  // 创建导出链接
  var link = document.createElement("a");
  link.setAttribute("href", "data:text/csv;charset=utf-8," + encodedCSVContent);
  link.setAttribute("download", filename);
  
  // 模拟点击下载
  link.click();
}

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

exportCSV(data, "export.csv");