JS-XLSX 库的表头样式设置示例
时间: 2024-01-08 17:02:39 浏览: 50
以下是一个示例代码,演示如何设置表头样式:
```javascript
var workbook = XLSX.utils.book_new();
var worksheet = XLSX.utils.json_to_sheet([
{ name: "John Doe", age: 35 },
{ name: "Jane Doe", age: 28 },
]);
// 定义表头样式
const headerStyle = {
font: { sz: 14, bold: true, color: { rgb: "FFFFFF" } },
fill: { patternType: "solid", fgColor: { rgb: "0070C0" } },
border: {
top: { style: "thin", color: { auto: 1 } },
right: { style: "thin", color: { auto: 1 } },
bottom: { style: "thin", color: { auto: 1 } },
left: { style: "thin", color: { auto: 1 } },
},
alignment: { horizontal: "center", vertical: "center", wrapText: true },
};
// 设置表头样式
Object.keys(worksheet).forEach(function (cell) {
if (cell[0] === "A") {
worksheet[cell].s = headerStyle;
}
});
XLSX.utils.book_append_sheet(workbook, worksheet, "Sheet1");
XLSX.writeFile(workbook, "example.xlsx");
```
在上面的示例中,表头样式被定义为常量`headerStyle`,包括了字体、填充、边框、对齐等属性。通过`Object.keys(worksheet).forEach`方法遍历所有单元格,找到第一列(A列)的单元格,设置其样式为表头样式。最终生成的Excel文件中,第一列的单元格将具有表头样式。