Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function readData() {
- var coordinates = [1, 1, 1, 26];
- reset();
- var range = read(coordinates);
- storeData(range);
- logProperties();
- }
- function read(coordinates) {
- Logger.log(coordinates.toString());
- var spreadSheet = SpreadsheetApp.openById("1L3Sd-J780mQtb7JYsmJzInI1kMdrQA8GbLspQJ5eVW4");
- var sheet = spreadSheet.getSheetByName("tracker");
- var range = sheet.getRange(coordinates[0], coordinates[1], coordinates[2], coordinates[3]).getValues();
- return JSON.stringify(range);
- }
- function logProperties() {
- var keys = PropertiesService.getScriptProperties().getKeys();
- Logger.log(keys);
- }
- function reset() {
- PropertiesService.getScriptProperties().deleteAllProperties();}
- function storeData(range) {
- Logger.log(range);
- }
- Execution log
- 1:48:00 AM Notice Execution started
- 1:48:01 AM Info 1,1,1,26
- 1:48:01 AM Info [["one","two","three","four","five","","","","","","","","","","","","","","","","","","","","",""]]
- 1:48:01 AM Info []
- 1:48:01 AM Notice Execution completed
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement