/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 vote294 views1 answer
I like
TypeScript
-1 vote292 views1 answer
Where to put toaster on http service calls typescript
TypeScript
8 votes305 views2 answers
Comment on blade laravel
TypeScript
0 vote358 views1 answer
Allowsyntheticdefaultimports angular
TypeScript
0 vote291 views1 answer
From date and to date validation in angular 8
TypeScript
0 vote299 views1 answer
Typescript sort number array descending
TypeScript
0 vote302 views1 answer
The react-scripts package provided by Create React App requires a dependency: [1] [1] "webpack": "4.42.0"
TypeScript
-1 vote277 views1 answer
How many continents are there
TypeScript
0 vote283 views1 answer
The dialect mongodb+srv is not supported. Supported dialects feathers
TypeScript
0 vote285 views1 answer
Url prod
TypeScript