数组元素为数组

  1. var data = [
  2.     ["rahul", "delhi", "accounts dept"],
  3.     ["rajeev", "UP", "sales dept"]
  4. ];
  6. exportData(data);
  8. function exportData(data) {
  9.     let csvContent = "data:text/csv;charset=utf-8,";
  10.     data.forEach(function(rowArray) {
  11.           let row = rowArray.join(",");
  12.           csvContent += row + "\r\n";
  13.     });
  15.     // 或者使用map及箭头函数可以让代码更简短
  16.     // csvContent = "data:text/csv;charset=utf-8,"  + data.map(e => e.join(",")).join("\n");
  18.     let encodedUri = encodeURI(csvContent);
  19.     // window.open(encodedUri);
  20.     let link = document.createElement("a");
  21.     link.setAttribute("href", encodedUri);
  22.     link.setAttribute("download", "my_data.csv");
  23.     document.body.appendChild(link); 
  24.     link.click();
  25. }

数组元素为对象

  1. var data = [
  2.       { name: 'jack', age: 20 },
  3.     { name: 'rose', age: 18 },
  4. ];
  6. exportData(data);
  8. function exportData(data) {
  9.     let csvContent = "data:text/csv;charset=utf-8,";
  10.     data.forEach(function(row, index) {
  11.       // 将对象元素的属性名称作为表头
  12.       if (index == 0) {
  13.             csvContent += Object.keys(row).join(",") + "\r\n";
  14.       }
  15.       csvContent += Object.values(row).join(",") + "\r\n";
  16.     });
  17.     let encodedUri = encodeURI(csvContent);
  18.     // window.open(encodedUri);
  19.     let link = document.createElement("a");
  20.     link.setAttribute("href", encodedUri);
  21.     link.setAttribute("download", "my_data.csv");
  22.     document.body.appendChild(link); 
  23.     link.click();
  24. }