ExcelJS node: horizontalCentered & verticalCentered in page not working

Question

plz help me.

My flow:

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

Template file:

Center on page:

• horizontally : Checked
• vertically : Checked

Source coder:

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

BUT File output:

• horizontal : uncheck
• vertical : uncheck

Answer 1

Please tell me if this worked well or not.

// 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
    }
  }
})

Answer 2

Please check below link and code.

https://github.com/Great-hijack/react-excel/blob/master/frontend/src/utils/export2excel.js

var sheet1 = workbook.addWorksheet('Download', { properties: { tabColor: { argb: '6B5B95' }, defaultRowHeight: 39 } });
// Page Setup for sheet1
sheet1.pageSetup.paperSize = 13; // B5 (JIS)
sheet1.pageSetup.orientation = 'landscape';
sheet1.pageSetup.horizontalCentered = true;
sheet1.pageSetup.verticalCentered = true;
sheet1.pageSetup.margins = {
    left: 0.7, right: 0.7,
    top: 0.3, bottom: 0.3,
    header: 0.3, footer: 0.3
};

I hope this is helpful for you.