Advertisement
nsaunders

Untitled

Oct 15th, 2022
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. function readData() {
  2. var coordinates = [1, 1, 1, 26];
  3. reset();
  4. var range = read(coordinates);
  5. storeData(range);
  6. logProperties();
  7. }
  8.  
  9. function read(coordinates) {
  10. Logger.log(coordinates.toString());
  11. var spreadSheet = SpreadsheetApp.openById("1L3Sd-J780mQtb7JYsmJzInI1kMdrQA8GbLspQJ5eVW4");
  12. var sheet = spreadSheet.getSheetByName("tracker");
  13. var range = sheet.getRange(coordinates[0], coordinates[1], coordinates[2], coordinates[3]).getValues();
  14. return JSON.stringify(range);
  15. }
  16.  
  17. function logProperties() {
  18. var keys = PropertiesService.getScriptProperties().getKeys();
  19. Logger.log(keys);
  20. }
  21.  
  22. function reset() {
  23. PropertiesService.getScriptProperties().deleteAllProperties();}
  24.  
  25. function storeData(range) {
  26. Logger.log(range);
  27. }
  28.  
  29.  
  30.  
  31.  
  32. Execution log
  33. 1:48:00 AM Notice Execution started
  34. 1:48:01 AM Info 1,1,1,26
  35. 1:48:01 AM Info [["one","two","three","four","five","","","","","","","","","","","","","","","","","","","","",""]]
  36. 1:48:01 AM Info []
  37. 1:48:01 AM Notice Execution completed
  38.  
  39.  
  40.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement