前端excel导出

61 阅读1分钟

` const exportExcel = () => { const { list } = datasList; const excel = []; for (let i = 0; i < list.length; i++) { let item: any = {}; item.id = list[i].id; item.propagandaName = list[i].propagandaName; item.gmtCreate = list[i].gmtCreate;

  excel.push(item);
}
console.log(excel, 'excel');

let str = `宣导名,宣导类型,负责人\n`;

for (let i = 0; i < excel?.length; i++) {
  for (let item in excel[i]) {
    str += `${excel[i][item] + '\t'},`;
  }
  str += '\n';
}
let uri = 'data:text/csv;charset=utf-8,\ufeff' + encodeURIComponent(str);
var link = document.createElement("a");
link.href = uri;
link.download = "json数据表.csv";
document.body.appendChild(link);
link.click();
document.body.removeChild(link);

};`