-
Notifications
You must be signed in to change notification settings - Fork 0
/
CodeTest.ts
21 lines (18 loc) · 771 Bytes
/
CodeTest.ts
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
function logActiveSheetData() {
Logger.log(`active sheet data:\n${JSON.stringify(getSheetData())}`);
}
function logColumnCombos() {
const data = getSheetData();
const columns = rowsToColumnsFlat(data.slice(1));
Logger.log(`header row:\n${JSON.stringify(data.slice(0, 1))}`);
Logger.log(`data (rows)\n${JSON.stringify(data.slice(1))}`);
Logger.log(`data (columns)\n${JSON.stringify(columns)}`);
Logger.log(`column combinations:\n${JSON.stringify(combinations(columns))}`);
}
function logSheetNames() {
Logger.log(`sheet names:\n${JSON.stringify(getSheetNames())}`);
}
function testWriteColumnCombos() {
// write data from Sheet1 to Sheet3 assuming row 1 in Sheet1 is a header row
writeColumnCombos({src: 'Sheet1', dest: 'Sheet3', header: true});
}