rmalcoriza

Dyson RefreshData

May 29th, 2020 (edited)
687
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function refreshData() {
  2.  
  3.   var ss = SpreadsheetApp.openById("16S5iRo_IkEvmzhVinqGqJbl8nbOyowfsb3834cmPS60")
  4.   var ukSheet = ss.getSheetByName("!calculationsUK")
  5.   var deSheet = ss.getSheetByName("!calculationsDE")
  6.   var frSheet = ss.getSheetByName("!calculationsFR")
  7.   var itSheet = ss.getSheetByName("!calculationsIT")
  8.  
  9.   SpreadsheetApp.flush();
  10.   for(i=2;i<=12;i++){
  11.      ukSheet.getRange('C'+i).clearContent();
  12.      ukSheet.getRange('C'+i).setFormula("=ROUND(getWeather(A"+i+",B"+i+",\"temperature\"))");
  13.   }
  14.  
  15.   for(i=2;i<=10;i++){
  16.      deSheet.getRange('C'+i).clearContent();
  17.      deSheet.getRange('C'+i).setFormula("=ROUND(getWeather(A"+i+",B"+i+",\"temperature\"))");
  18.   }
  19.  
  20.   for(i=2;i<=8;i++){
  21.      frSheet.getRange('C'+i).clearContent();
  22.      frSheet.getRange('C'+i).setFormula("=ROUND(getWeather(A"+i+",B"+i+",\"temperature\"))");
  23.   }
  24.  
  25.   for(i=2;i<=12;i++){
  26.      itSheet.getRange('C'+i).clearContent();
  27.      itSheet.getRange('C'+i).setFormula("=ROUND(getWeather(A"+i+",B"+i+",\"temperature\"))");
  28.   }
  29.   SpreadsheetApp.flush();
  30. }
Add Comment
Please, Sign In to add comment