1、直接下载html中的表格元素
<table id="table" border="1">
<tr style="height:50px;">
<th style="width:100px;color:red;">姓名</th>
<th>性别</th>
<th>年龄</th>
</tr>
</table>
<a id="down">点击下载excel</a>
<script>
let html = `<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
</head>
<body>
${document.getElementById('table').outerHTML}
</body>
</html>`
let blob = new Blob([html],{ type: 'application/vnd.ms-excel'});
let a = document.getElementById('down');
a.href = URL.createObjectURL(blob);
a.download = '测试excel下载'
</script>
原文链接:https://blog.csdn.net/weixin_35958891/article/details/103381012
2、npm install node-xlsx
接口返回的数据,再处理成map对象或者数组对象,再写入到excel
downloadFile(){
const xlsx = require('xlsx');
let arrayData = [
['name', 'age'],
['zhangsan', 20]
];
let jsonData = [{
name: "zhangsan1",
age: 30
},
{
name: "zhangsan1",
age: 24
}
];
// 将数据转成workSheet
let arrayWorkSheet = xlsx.utils.aoa_to_sheet(arrayData);
let jsonWorkSheet = xlsx.utils.json_to_sheet(jsonData);
// 构造workBook
let workBook = {
SheetNames: ['arrayWorkSheet', 'jsonWorkSheet'],
Sheets: {
'arrayWorkSheet': arrayWorkSheet,
'jsonWorkSheet': jsonWorkSheet,
}
};
// 将workBook写入文件
xlsx.writeFile(workBook, "./aa.xlsx");
}
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)