Function buildReleaseNotesSheet

scripts/createExcelSheet.mjs:60–100

(workbook, {v3PRs, s2PRs, racPRs, otherPRs, offPRs})

}

function buildReleaseNotesSheet(workbook, {v3PRs, s2PRs, racPRs, otherPRs, offPRs}) {
  let sheet = workbook.addWorksheet('Release Notes');

  sheet.columns = [{width: 25}, {width: 70}, {width: 50}, {width: 50}];
  sheet.getColumn(2).alignment = {wrapText: true, vertical: 'top'};
  sheet.getColumn(4).alignment = {wrapText: true, vertical: 'top'};

  let groups = [
    ['RAC', racPRs],
    ['S2', s2PRs],
    ['V3', v3PRs],
    ['Other', otherPRs],
    ['Off PRs', offPRs]
  ];

  for (let [name, rows] of groups) {
    if (!rows || rows.length === 0) {
      continue;
    }

    let headingRow = sheet.addRow([name]);
    headingRow.getCell(1).font = {bold: true};

    for (let row of rows) {
      let sanitized = [
        sanitizeExcelString(row[0]),
        sanitizeExcelString(row[1]),
        null,
        sanitizeExcelString(row[3])
      ];
      let added = sheet.addRow(sanitized);
      let url = row[2];
      if (url) {
        added.getCell(3).value = {text: url, hyperlink: url};
        added.getCell(3).font = {color: {argb: 'FF0563C1'}, underline: true};
      }
    }

    sheet.addRow([]);
  }
}

function buildPassFailSheet(workbook, {v3PRs, s2PRs, racPRs, otherPRs, offPRs}) {
  let sheet = workbook.addWorksheet('Pass-Fail');