Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function refreshData() {
- var ss = SpreadsheetApp.openById("16S5iRo_IkEvmzhVinqGqJbl8nbOyowfsb3834cmPS60")
- var ukSheet = ss.getSheetByName("!calculationsUK")
- var deSheet = ss.getSheetByName("!calculationsDE")
- var frSheet = ss.getSheetByName("!calculationsFR")
- var itSheet = ss.getSheetByName("!calculationsIT")
- SpreadsheetApp.flush();
- for(i=2;i<=12;i++){
- ukSheet.getRange('C'+i).clearContent();
- ukSheet.getRange('C'+i).setFormula("=ROUND(getWeather(A"+i+",B"+i+",\"temperature\"))");
- }
- for(i=2;i<=10;i++){
- deSheet.getRange('C'+i).clearContent();
- deSheet.getRange('C'+i).setFormula("=ROUND(getWeather(A"+i+",B"+i+",\"temperature\"))");
- }
- for(i=2;i<=8;i++){
- frSheet.getRange('C'+i).clearContent();
- frSheet.getRange('C'+i).setFormula("=ROUND(getWeather(A"+i+",B"+i+",\"temperature\"))");
- }
- for(i=2;i<=12;i++){
- itSheet.getRange('C'+i).clearContent();
- itSheet.getRange('C'+i).setFormula("=ROUND(getWeather(A"+i+",B"+i+",\"temperature\"))");
- }
- SpreadsheetApp.flush();
- }
Add Comment
Please, Sign In to add comment