workbook.md

Workbook Operations — @office-core/exceljs⬆

Create a Workbook⬆

const workbook = new ExcelJS.Workbook();

Set Workbook Properties⬆

workbook.creator = 'Me';
workbook.lastModifiedBy = 'Her';
workbook.created = new Date(1985, 8, 30);
workbook.modified = new Date();
workbook.lastPrinted = new Date(2016, 9, 27);

// Set workbook dates to 1904 date system
workbook.properties.date1904 = true;

Set Calculation Properties⬆

// Force workbook calculation on load
workbook.calcProperties.fullCalcOnLoad = true;

Workbook Views⬆

The Workbook views controls how many separate windows Excel will open when viewing the workbook.

workbook.views = [
  {
    x: 0, y: 0, width: 10000, height: 20000,
    firstSheet: 0, activeTab: 1, visibility: 'visible'
  }
]