javascript - ExcelJS Node : horizontalCentered & verticalCentered in page not working

Question

请帮助我。

我的流量:

Using a file Tempate -> Code (Exceljs) -> output New file

模板文件:


页面居中:

水平:检查

垂直:检查

源代码:

worksheet.pageSetup.horizontalCentered = true 
worksheet.pageSetup.verticalCentered = true

但是文件输出:

水平:取消选中

垂直:取消选中

Answer 1

请告诉我这是否有效。

// DO NOT SET ANOTHER pageSetup AFTER DECLARING THIS!

var worksheet =  workbook.addWorksheet('sheet', {
  pageSetup: {
    horizontalCentered: true,
    verticalCentered: true,
    paperSize: 9,
    orientation: 'portrait',
    margins: {
      left: 0.3149606, right: 0.3149606,
      top: 0.3543307, bottom: 0.3543307,
      header: 0.3149606, footer: 0.3149606
    }
  }
})