<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>exceljs 使用</title>
</head>
<body>
<button onclick="exporting()">导出</button>
<script>
function exporting() {
// 创建工作簿
const _workbook = new ExcelJS.Workbook()
// 添加工作表
const _sheet1 = _workbook.addWorksheet('sheet1')
// 配置导出表格
_sheet1.addTable({
name: 'MyTestTable',
ref: 'A1', // 表格左上角的位置
headerRow: true,
totalsRow: false,
style: {
theme: 'TableStyleLight1',
// showRowStripes: true,
},
columns: [{
header: '名次',
key: 'sort',
width: 10
},
{
header: '班级',
key: 'class',
width: 20
},
{
header: '姓名',
key: 'name',
width: 20
},
{
header: '得分',
key: 'score',
width: 10
},
],
rows: [{
sort: 1,
class: '前端三班',
name: 'Buer',
score: 99
},
{
sort: 2,
class: '前端一班',
name: 'Jack',
score: 86
},
{
sort: 3,
class: '前端一班',
name: 'Mary',
score: 58
}
],
})
_sheet1.getRow(1).border = {
top: {
style: 'thin'
},
left: {
style: 'thin'
},
bottom: {
style: 'thin'
},
right: {
style: 'thin'
},
}
_sheet1.getRow(1).font = {
bold: true,
}
// 导出表格
_workbook.xlsx.writeBuffer().then((buffer) => {
let _file = new Blob([buffer], {
type: 'application/octet-stream',
})
const blob = new Blob([buffer], {
type: 'arraybuffer'
})
const link = document.createElement('a')
link.href = URL.createObjectURL(blob)
link.download = '测试' + '.xlsx'
link.click()
URL.revokeObjectURL(link.href) // 下载完成释放掉blob对象
})
}
</script>
<script src="https://cdn.jsdelivr.net/npm/exceljs@4.4.0"></script>
</body>
</html>
