forked from googleworkspace/apps-script-samples
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathhelpers.gs
More file actions
44 lines (38 loc) · 1.1 KB
/
helpers.gs
File metadata and controls
44 lines (38 loc) · 1.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
let filesToDelete = [];
/**
* Helper methods for Google Sheets tests.
*/
function Helpers() {
this.filesToDelete = [];
}
Helpers.prototype.reset = function() {
this.filesToDelete = [];
};
Helpers.prototype.deleteFileOnCleanup = function(id) {
this.filesToDelete.push(id);
};
Helpers.prototype.cleanup = function() {
filesToDelete.forEach(Drive.Files.remove);
};
Helpers.prototype.createTestSpreadsheet = function() {
const spreadsheet = SpreadsheetApp.create('Test Spreadsheet');
for (let i = 0; i < 3; ++i) {
spreadsheet.appendRow([1, 2, 3]);
}
this.deleteFileOnCleanup(spreadsheet.getId());
return spreadsheet.getId();
};
Helpers.prototype.populateValues = function(spreadsheetId) {
const batchUpdateRequest = Sheets.newBatchUpdateSpreadsheetRequest();
const repeatCellRequest = Sheets.newRepeatCellRequest();
let values = [];
for (let i = 0; i < 10; ++i) {
values[i] = [];
for (let j = 0; j < 10; ++j) {
values[i].push('Hello');
}
}
let range = 'A1:J10';
SpreadsheetApp.openById(spreadsheetId).getRange(range).setValues(values);
SpreadsheetApp.flush();
};