"exceljs": "^4.2.0",
npm install exceljs
import {Workbook} from 'exceljs';
const workbook = new Workbook;
const sheet = workbook.addWorksheet('Sheet1', {properties:{defaultRowHeight:25}});
sheet.pageSetup.horizontalCentered = true;
sheet.pageSetup.verticalCentered = true;
sheet.columns = [
{header:'title1',key:'title1',width: 25,style:{alignment:{vertical:'middle',horizontal:'center'}}},
{header:'title2',key:'title2',width: 25,style:{alignment:{vertical:'middle',horizontal:'center'}}},
{header:'title3',key:'title3',width: 30,style:{alignment:{vertical:'middle',horizontal:'center'}}},
];
sheet.addRow({title1: '111',
title2: '222',
title3: '333',
});
sheet.addRow({title1: '444',
title2: '555',
title3: '666',
});
sheet.mergeCells(1,1,2,2);
workbook.xlsx.writeBuffer().then((buffer) => {
writeFile('Capability.xlsx', buffer);
});
const writeFile = (fileName, content) => {
let a = document.createElement("a");
let blob = new Blob([content], { type: "text/plain" });
a.download = fileName;
a.href = URL.createObjectURL(blob);
a.click();
};
ref:https://github.com/exceljs/exceljs/blob/master/README_zh.md