js导出科学计数法_js数据导出为Excel-CSDN博客

本文链接：https://blog.csdn.net/weixin_35642839/article/details/112263737

//导出Excel
print_table_excel: function () {
       let objArr = [];
       let jsonData = [];
       for (let j = 0; j < that.thisCommData.curr_config_table_data.logLineList.length; j++) {
            let pre_obj = {};
            for (let i = 0; i < that.thisCommData.curr_config_table_data.logLineList[j].blockList.length; i++) {
                 let curr_value = that.thisCommData.curr_config_table_data.logLineList[j].blockList[i];
                 var tempArray = ['', 'value_int', 'value_decimal', 'value_varchar', 'value_text'];
                 pre_obj['主订单'] = that.thisCommData.curr_config_table_data.logLineList[j].main_order_title;
                 pre_obj[curr_value.head_name] = this.setHtmlValueFun(curr_value);
             }
             objArr.push(pre_obj);
        }
        //要导出的json数据
        jsonData = objArr;
        //列标题，逗号隔开，每一个逗号就是隔开一个单元格
        let str = `主订单,`;
        for(let i=0;i<that.thisCommData.curr_config_table_data.headList.length;i++){
            str += that.thisCommData.curr_config_table_data.headList[i].head_name + ',';
        }
        str += 'n';

        //增加t为了不让表格显示科学计数法或者其他格式
        for (let i = 0; i < jsonData.length; i++) {
             for (let item in jsonData[i]) {
                  //str += `${jsonData[i][item] + 't'},`;
                  str += `${jsonData[i][item]},`;
             }
             str += 'n';
        }
        str += 'n';

       //encodeURIComponent解决中文乱码
       let uri = 'data:text/csv;charset=utf-8,ufeff' + encodeURIComponent(str);
       //通过创建a标签实现
       var link = document.createElement("a");
       link.href = uri;
       //对下载的文件命名
       link.download = that.thisCommData.curr_config_table_data.table_name + ".csv";

       document.body.appendChild(link);
       link.click();
       document.body.removeChild(link);

}