前端导出对象或者 JSON 数据为 CSV 文件

参考博客

前端导出表格为CSV文件功能

代码

getExportList() {
  let jsonData = {
      trade:{
        tHeader: ["名字","性别","年龄","爱好","身份证号码"],
        filterVal: ["name","sex","nlin","aihao","sfz"],
        list: [{name: "名字啊",sex: "性别啊",aihao: "爱好啊",nlin:"年龄啊",sfz:"123456789012345678"},
              {name: "名字哦",sex: "性别哦",nlin:"年龄哦",aihao: "爱好哦",sfz:"123456789012345678"}]
      },
      order:{
        tHeader: ["附表名字","附表性别","附表年龄","附表爱好"],
        filterVal: ["name","sex","nlin","aihao"],
        list: [{name: "附表名字啊",sex: "附表性别啊",nlin:"附表年龄啊",aihao: "附表爱好啊",},
               {name: "附表名字哦",sex: "附表性别哦",nlin:"附表年龄哦",aihao: "附表爱好哦",}]
        }
    }    
    this.exportPathMethod(jsonData)// 调用exportPathMethod对数据进行处理导出
 },

exportPathMethod(data) {
    /*
    *注：csv文件：","逗号换列，\n换行，\t防止excel将长数字变科学计算法等样式
    */

    //要导出的json数据
    let mainLists = data.trade   //主表
    let subLists = data.order    //副表
    
    //## 数据处理
    //一级表
    let mainTitle = mainLists.tHeader;//一级标题
    let mainTitleForKey = mainLists.filterVal;//一级过滤
    let mainList = mainLists.list;//一级数据
    let mainStr = [];
    mainStr.push(mainTitle.join("\t,")+"\n");   //标题添加上换列转成字符串并存进数组
    for(let i=0;i