Table 表格导出功能

不念不忘少年蓝@ 2022-12-31 04:21 235阅读 0赞

![在这里插入图片描述][20201228112642631.png]

// 导出列表头 1
          queryColumns11: [
            { 
              title: "项目名称",
              key: "projectName",
              align: "center",
              width: 200,
            },
            { 
              title: "收入类型",
              key: "revenueType",
              align: "center",
              width: 150,
            },
            { 
              title: "年度",
              key: "year",
              align: "center",
              width: 150,
            },
            { 
              title: "1月",
              key: "monthAmount1",
              align: "center",
              width: 150,
            },
            { 
              title: "2月",
              key: "monthAmount2",
              align: "center",
              width: 150,
            },
            { 
              title: "3月",
              key: "monthAmount3",
              align: "center",
              width: 150,
            },
            { 
              title: "4月",
              key: "monthAmount4",
              align: "center",
              width: 150,
            },
            { 
              title: "5月",
              key: "monthAmount5",
              align: "center",
              width: 150,
            },
            { 
              title: "6月",
              key: "monthAmount6",
              align: "center",
              width: 150,
            },
            { 
              title: "7月",
              key: "monthAmount7",
              align: "center",
              width: 150,
            },
            { 
              title: "8月",
              key: "monthAmount8",
              align: "center",
              width: 150,
            },
            { 
              title: "9月",
              key: "monthAmount9",
              align: "center",
              width: 150,
            },
            { 
              title: "10月",
              key: "monthAmount10",
              align: "center",
              width: 150,
            },
            { 
              title: "11月",
              key: "monthAmount11",
              align: "center",
              width: 150,
            },
            { 
              title: "12月",
              key: "monthAmount12",
              align: "center",
              width: 150,
            },
            { 
              title: "年度累计",
              key: "monthAmount13",
              align: "center",
              width: 200,
            },
            { 
              title: "更新时间",
              key: "updateTime",
              align: "center",
              width: 200,
            },
          ],

//导出收入信息
        exportExcel1() { 
          this.$Spin.show({ 
            render: (h) => { 
              return h("div", [
                h("Icon", { 
                  class: "demo-spin-icon-load",
                  props: { 
                    type: "load-c",
                    size: 50,
                  },
                }),
                h("div", "努力记载中...."),
              ]);
            },
          });
          this.excell = [];
          new Promise((resolve, reject) => { 
            ApiDrug.exportincomeExport({ })
              .then((response) => { 
                let res = response.result;
                res.forEach((item, index) => { 
                  item.monthAmount1 = item.monthAmount["1"];
                  item.monthAmount2 = item.monthAmount["2"];
                  item.monthAmount3 = item.monthAmount["3"];
                  item.monthAmount4 = item.monthAmount["4"];
                  item.monthAmount5 = item.monthAmount["5"];
                  item.monthAmount6 = item.monthAmount["6"];
                  item.monthAmount7 = item.monthAmount["7"];
                  item.monthAmount8 = item.monthAmount["8"];
                  item.monthAmount9 = item.monthAmount["9"];
                  item.monthAmount10 = item.monthAmount["10"];
                  item.monthAmount11 = item.monthAmount["11"];
                  item.monthAmount12 = item.monthAmount["12"];
                  item.monthAmount13 = 0;
                  if (item.revenueType == "2") { 
                    item.revenueType = "药品服务费收入";
                  }
                  if (item.revenueType == "3") { 
                    item.revenueType = "特药服务费收入";
                  }
                  if (item.revenueType == "4") { 
                    item.revenueType = "直保经纪费";
                  }
                  if (item.revenueType == "5") { 
                    item.revenueType = "再保经纪费";
                  }
                  if (item.revenueType == "6") { 
                    item.revenueType = "广告费";
                  }
                  for (const key in item.monthAmount) { 
                    item.monthAmount13 += item.monthAmount[key];
                  }
                });
                this.excel = response.result;
                this.excell = this.excel;
                // 导出方法 利用Vue 的 ref 获取所需的dom节点进行方法设置
                this.$refs.table.exportCsv({ 
                //导出文件标题
                  filename: "收入信息",
                  //导出文件集合（内容）
                  columns: this.queryColumns11.filter(
                    (col, index) => index < 100000
                  ),
                  data: this.excel.filter((data, index) => index < 100000),
                });
                this.$Spin.hide();
                resolve();
              })
              .catch((error) => { 
                this.$Spin.hide();
                reject(error);
              });
          });
        },

[20201228112642631.png]: /images/20221120/dea07c8a83fb419bbd89df28855fb6f2.png