/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 vote106 views1 answer
Pass command line arguments C#
TypeScript
1 vote116 views2 answers
Show all posts from category
TypeScript
0 vote118 views1 answer
Error NG8001
TypeScript
0 vote118 views1 answer
Typescript time
TypeScript
28 votes106 views4 answers
Install typescript
TypeScript
3 votes119 views2 answers
Exists query elasticsearch 5.4
TypeScript
12 votes153 views4 answers
Delete contents of directory python
TypeScript
0 vote103 views1 answer
Coding Exercise: Double Time Modify this recursive program to correctly count down in increments of 2.
TypeScript
7 votes108 views2 answers
Conditional style angular
TypeScript
5 votes108 views1 answer
Fontawesome , font
TypeScript