js-xlsx :在写入.xlsx文件时保留单元格样式

npm install xlsx-style

var XLSX = require('xlsx-style');

var wb = XLSX.utils.book_new();
var ws_data = [['hello', 'world']];
var ws = XLSX.utils.aoa_to_sheet(ws_data);

// 设置A1单元格的样式
ws['A1'].s = {
  fill: {
    fgColor: {rgb: "FFFFAA00"}
  },
  font: {
    sz: 14,
    bold: true,
    color: {rgb: "FF00FF00"}
  },
  alignment: {
    horizontal: "center",
    vertical: "center"
  }
};

XLSX.utils.book_append_sheet(wb, ws, "Sheet1");

XLSX.writeFile(wb, "out.xlsx");