前端使用XLSX插件实现导出功能,具体代码实现:
1.npm install xlsx --save 下载安装xlsx插件依赖包
2.在使用得地方引入import XLSX, { utils } from ‘xlsx’;
* @description:
* @param {Object} json 服务端发过来的数据
* @param {String} name 导出Excel文件名字
* @param {String} titleArr 导出Excel表头
* @param {String} sheetName 导出sheetName名字
* @return:
*/
exportExcel(json, name, titleArr, sheetName) {
/* convert state to workbook */
var data = new Array();
var keyArray = new Array();
const getLength = function (obj) {
var count = 0;
for (var i in obj) {
if (obj.hasOwnProperty(i)) {
count++;
}
}
return count;
};
for (const key1 in json) {
if (json.hasOwnProperty(key1)) {
const element = json[key1];
var rowDataArray = new Array();
for (const key2 in element) {
if (element.hasOwnProperty(key2)) {
const element2 = element[key2];
rowDataArray.push(element2);
if (keyArray.length < getLength(element)) {
keyArray.push(key2);
}
}
}
data.push(rowDataArray);
}
}
// keyArray为英文字段表头
data.splice(0, 0, keyArray, titleArr);
console.log('data', data);
const ws = XLSX.utils.aoa_to_sheet(data);
const wb = XLSX.utils.book_new();
// 此处隐藏英文字段表头
var wsrows = [{ hidden: true }];
ws['!rows'] = wsrows; // ws - worksheet
XLSX.utils.book_append_sheet(wb, ws, sheetName);
/* generate file and send to client */
XLSX.writeFile(wb, name + '.xlsx');
};
// 使用
private async exportOut() {
let titleArr: any = ['中文表头1', '中文表头2', '中文表头3', '中文表头4', '中文表头5', '中文表头6'];
let params = {
a: 1,
b: 2
};
const res = await get(ApiUrl.getUrl, params);
if (res.code === 200) {
Excel.exportExcel(res.data, 'excelName', titleArr, 'sheetName');
this.$message({
message: '导出成功',
type: 'success'
});
} else {
this.$message.error(res.msg);
}
}