第一种(数组的导出)
npm i -S file-saver xlsx
npm i -S script-loader
在这里插入图片描述

写两个方法

exportData () {
      const { export_json_to_excel } = require('@/vendor/Export2Excel');
      const tHeader = ['列1', '列2', '列3'];
      const filterVal = ['row1', 'row2', 'row2'];
      const list = this.tableData;
      const data = this.formatJson(filterVal, list);
      export_json_to_excel(tHeader, data, 'fileName');
    },

    formatJson (filterVal, jsonData) {
      return jsonData.map(v => filterVal.map(j => v[j]))
    }

tableData是需要导出的数组
http://www.manongjc.com/detail/16-fxcffaekpprojck.html 原文

第二种(elementui的表格)
https://blog.csdn.net/qq_40611595/article/details/119459716utm_medium=distribute.pc_aggpage_search_result.none-task-blog-2aggregatepagefirst_rank_ecpm_v1~rank_v31_ecpm-1-119459716.pc_agg_new_rank&utm_term=vue%E5%AE%9E%E7%8E%B0%E5%AF%BC%E5%87%BA%E5%8A%9F%E8%83%BD&spm=1000.2123.3001.4430 原文
解决重复数据问题
https://blog.csdn.net/qq_37916164/article/details/119967845?utm_medium=distribute.pc_relevant.none-task-blog-2defaultbaidujs_title~default-0.pc_relevant_aa&spm=1001.2101.3001.4242.1&utm_relevant_index=3

npm install --save xlsx file-saver

npm install --save xlsx file-saver

Logo

前往低代码交流专区

更多推荐