/TypeScript/Google sheets automatic update rook

Google sheets automatic update rook

function storeFollowers(){
    var sheet = SpreadsheetApp.getActiveSheet();
    var datarange = sheet.getDataRange();
    var numRows = datarange.getNumRows();
    var numColumns = datarange.getNumColumns();
    var nextColumn = numColumns + 1;
    sheet.getRange(1, nextColumn).setValue(new Date());
    for (var i=2; i <= numRows; i++){
      var numLikes = sheet.getRange(i, 3).getValue();
      sheet.getRange(i, numColumns + 1).setValue(numLikes);
    }
}

Source: computerworld.com

Similar codes

0 vote165 views1 answer
Python shuffle two lists together
TypeScript
3 votes129 views1 answer
'mat-form-field' is not a known element:
TypeScript
0 vote155 views1 answer
Auto complete of process.env in typescript
TypeScript
0 vote173 views1 answer
Non-abstract class does not implement inherited abstract member typescript
TypeScript
0 vote167 views1 answer
Angular build Failed to load resource
TypeScript
7 votes135 views3 answers
Convert double list to single list python
TypeScript
2 votes130 views2 answers
Vue 3 setup props typescript
TypeScript
1 vote135 views2 answers
Alerts in material ui
TypeScript
1 vote156 views1 answer
File C:\Users\skill\AppData\Roaming\npm\yarn.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170.
TypeScript
0 vote176 views1 answer
Adoni migrate
TypeScript