MCPcopy Create free account
hub / github.com/adobe/react-spectrum / buildPassFailSheet

Function buildPassFailSheet

scripts/createExcelSheet.mjs:103–249  ·  view source on GitHub ↗
(workbook, {v3PRs, s2PRs, racPRs, aiPRs, otherPRs, offPRs})

Source from the content-addressed store, hash-verified

101}
102
103function buildPassFailSheet(workbook, {v3PRs, s2PRs, racPRs, aiPRs, otherPRs, offPRs}) {
104 let sheet = workbook.addWorksheet('Pass-Fail');
105
106 sheet.columns = [
107 {width: 25},
108 {width: 20},
109 {width: 25},
110 {width: 20},
111 {width: 20},
112 {width: 20},
113 {width: 20},
114 {width: 20}
115 ];
116 let categoryA = [
117 {row: 1, label: 'Storybook'},
118 {row: 2, label: 'S2 Docs'},
119 {row: 3, label: 'RAC Docs'},
120 {row: 4, label: 'S2 Storybook'},
121 {row: 6, label: 'PRs'}
122 ];
123
124 for (let {row, label} of categoryA) {
125 let cell = sheet.getCell(`A${row}`);
126 cell.value = label;
127 cell.font = {bold: true};
128 }
129
130 let docLinks = {
131 'S2 Docs': {b: 'https://d1pzu54gtk2aed.cloudfront.net/', c: 'https://tinyurl.com/4m778kj3'},
132 'RAC Docs': {b: 'https://d5iwopk28bdhl.cloudfront.net/', c: 'https://tinyurl.com/5ycw9yje'}
133 };
134 let linkFont = {color: {argb: 'FF0563C1'}, underline: true};
135 for (let {row, label} of categoryA) {
136 let links = docLinks[label];
137 if (!links) {
138 continue;
139 }
140 let bCell = sheet.getCell(`B${row}`);
141 bCell.value = {text: links.b, hyperlink: links.b};
142 bCell.font = linkFont;
143 let cCell = sheet.getCell(`C${row}`);
144 cCell.value = {text: links.c, hyperlink: links.c};
145 cCell.font = linkFont;
146 }
147
148 let categoryE = [
149 {row: 1, label: 'Test Apps'},
150 {row: 2, label: 'Next'},
151 {row: 3, label: 'S2 Parcel'},
152 {row: 4, label: 'S2 Webpack'},
153 {row: 5, label: 'S2 Next'},
154 {row: 6, label: 'S2 Vite'}
155 ];
156 for (let {row, label} of categoryE) {
157 sheet.getCell(`E${row}`).value = label;
158 }
159
160 let browserHeaders = [

Callers 1

createTestingSheetFunction · 0.85

Calls 2

sanitizeExcelStringFunction · 0.85
cfStyleFunction · 0.85

Tested by

no test coverage detected