Function buildPassFailSheet

scripts/createExcelSheet.mjs:102–245

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

}

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

  sheet.columns = [
    {width: 25},
    {width: 20},
    {width: 25},
    {width: 20},
    {width: 20},
    {width: 20},
    {width: 20},
    {width: 20}
  ];
  let categoryA = [
    {row: 1, label: 'Storybook'},
    {row: 2, label: 'S2 Docs'},
    {row: 3, label: 'RAC Docs'},
    {row: 4, label: 'S2 Storybook'},
    {row: 6, label: 'PRs'}
  ];

  for (let {row, label} of categoryA) {
    let cell = sheet.getCell(`A${row}`);
    cell.value = label;
    cell.font = {bold: true};
  }

  let docLinks = {
    'S2 Docs': {b: 'https://d1pzu54gtk2aed.cloudfront.net/', c: 'https://tinyurl.com/4m778kj3'},
    'RAC Docs': {b: 'https://d5iwopk28bdhl.cloudfront.net/', c: 'https://tinyurl.com/5ycw9yje'}
  };
  let linkFont = {color: {argb: 'FF0563C1'}, underline: true};
  for (let {row, label} of categoryA) {
    let links = docLinks[label];
    if (!links) {
      continue;
    }
    let bCell = sheet.getCell(`B${row}`);
    bCell.value = {text: links.b, hyperlink: links.b};
    bCell.font = linkFont;
    let cCell = sheet.getCell(`C${row}`);
    cCell.value = {text: links.c, hyperlink: links.c};
    cCell.font = linkFont;
  }

  let categoryE = [
    {row: 1, label: 'Test Apps'},
    {row: 2, label: 'Next'},
    {row: 3, label: 'S2 Parcel'},
    {row: 4, label: 'S2 Webpack'},
    {row: 5, label: 'RAC Tailwind'}
  ];
  for (let {row, label} of categoryE) {
    sheet.getCell(`E${row}`).value = label;
  }

  let browserHeaders = [
    'Component',