前端实现导出功能

1.前端实现导出原理：首先需要拿到需要导出的数据，然后执行导出方法

 downLoad() {
 //在这里拿到要导出的数据
      this.downloadLoading = true;
      let params = {
        ...JSON.parse(JSON.stringify(this.formInline)),
        pageSize: 99999999999,
        pageIndex: 0,
      };
      if (params.order_time && params.order_time.length > 0) {
        params.start_time = params.order_time[0];
        params.end_time = params.order_time[1];
      }
      delete params.order_time;
      situationList(params)
        .then((res) => {
          import("@/vendor/Export2Excel").then((excel) => {
            const tHeader = this.labelList.map((row) => row.label);
            const filterVal = this.labelList.map((row) => row.value);
            const data = this.formatJson(filterVal, res.data);
            excel.export_json_to_excel({
              header: tHeader,
              data,
              filename: "供应商采购数据",
              autoWidth: this.autoWidth,
              bookType: this.bookType,
            });
          });
        })
        .finally(() => {
          this.downloadLoading = false;
        });
    },```

```bash
 formatJson(filterVal, jsonData) {
      return jsonData.map((v) =>
        filterVal.map((j) => {
          if (j === "timestamp") {
            return parseTime(v[j]);
          } else {
            return v[j];
          }
        })
      );
    },

遇到比较不和谐的后端，什么都要前端来做，那也不用怕，后端可以做的前端一样可以做