导出excel表格功能

/**
* 导出excel 事件
*/
handleDownloadProjectData() {
let _this = this;
let tHeaderBase = ['项目编码', '项目名称', '组织架构','法人公司','曾用名','项目负责人',
'管理模式','合作方','我方权益比','项目纬度','项目经度','项目地址'];
let filterVal = ['code', 'name','oName','cName', 'alias','responsible',
'mName','partner','share','latitude','longitude','address'];
let sheetData1 = {};
let exportData = {};
sheetData1.titles = tHeaderBase;
sheetData1.sheetName = "项目抬头数据";
if(_this.multipleSelection.length!==0)
sheetData1.data = _this.formatJson(filterVal, _this.multipleSelection);
else
sheetData1.data = _this.formatJson(filterVal,_this.tableData);

exportData.sheetDatas = [];
exportData.exportFileName = "项目抬头明细";
exportData.sheetDatas.push(sheetData1);
document.getElementById("exportData").value = JSON.stringify(exportData);
let form = document.getElementById("exportForm");
form.action = "http://52.80.16.80:10185/api/service/exportExcel";
form.submit();
},
formatJson(filterVal, jsonData) {
return jsonData.map(v => filterVal.map(j => v[j]))
},
原文地址:https://www.cnblogs.com/yanerbaobao/p/7649029.html