Introduction

js前端生成excel文件(表格)并下载后台返回一段数据，前端遍历生成表格下载

Use

  2. function downLoadExcel(data, fileName) {
  3.   //定义表头
  4.   let str = `77\n用户名,时间,坐标,来源,授权时间\n`;
  5.   //增加\t为了不让表格显示科学计数法或者其他格式
  6.   for (let i = 0; i < data.length; i++) {
  7.     for (let item in data[i]) {
  8.       str += `${data[i][item] + '\t'},`;
  9.     }
  10.     str += '\n';
  11.   }
  12.   //encodeURIComponent解决中文乱码
  13.   let uri = 'data:text/xlsx;charset=utf-8,\ufeff' + encodeURIComponent(str);
  14.   //通过创建a标签实现
  15.   let link = document.createElement('a');
  16.   link.href = uri;
  17.   //对下载的文件命名
  18.   link.download = `${fileName || '表格数据'}.csv`;
  19.   document.body.appendChild(link);
  20.   link.click();
  21.   document.body.removeChild(link);
  22. }
  23. function clickDown() {
  24.   let tableData = [
  25.     {
  26.       name: '你好啊',
  27.       time: 130000000000,
  28.       pre: '127.130',
  29.       source: '淘宝',
  30.       otherTime: 1571276232000,
  31.     },
  32.     {
  33.       name: '2你好啊',
  34.       time: 5130000000000,
  35.       pre: '127.130',
  36.       source: '淘宝',
  37.       otherTime: 41571276232000,
  38.     },
  39.     {
  40.       name: '3你好啊',
  41.       time: 3130000000000,
  42.       pre: '127.130',
  43.       source: '淘宝',
  44.       otherTime: 21571276232000,
  45.     },
  46.   ];
  47.   downLoadExcel(tableData, '测试数据');
  48. }

Example

image.png
原文链接：https://blog.csdn.net/guoqiankunmiss/article/details/102609250