生成xlsx并下载--Export2Excel2

utils.excel.Export2Excel2

Export2Excel2

下载的时候直接

        import("@/utils/excel/Export2Excel2.js").then((excel) => {
          const tHeader = ["卡名称", "卡号", "卡类型", "Id", "手机号", "用户姓名", "余额", "开卡时间"]; //表头
          const filterVal = ["CardName", "CardNo", "CardType", "Id", "Phone", "RealName", "Balance", "UploadTime"]; //对应的值
          const list = that.dataList; //要导出的数据

          const data = that.formatJson(filterVal, list);
          excel.export_json_to_excel({
            filename: '退卡用户',
            header: tHeader,
            data,
          });
        });

数据处理

 //导出的数据格式处理
      formatJson(filterVal, jsonData) {
        return jsonData.map((v) =>
          filterVal.map((j) => {
            if (j == "Balance") {
              return v[j] / 100 + '元';
            } else if (j == "UploadTime") {
              return v[j].substring(0, 10) + '/' + v[j].substring(11, 18)
            } else {
              return v[j];
            }
          })
        );
      },