/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 vote118 views1 answer
Form control adding disabled and validators
TypeScript
2 votes126 views1 answer
How to get post of instragram using api
TypeScript
1 vote138 views1 answer
Ts disable is declared but its value is never read
TypeScript
0 vote136 views1 answer
Display only user contributor comments wordpress
TypeScript
0 vote130 views1 answer
Set environment variable typescript
TypeScript
0 vote128 views1 answer
Number square n times in typescript
TypeScript
0 vote134 views1 answer
There are 7 components with misconfigured ETags
TypeScript
1 vote139 views1 answer
Angular hide element from component when on certain page
TypeScript
0 vote139 views1 answer
Difference between scripted testing and exploratory testing
TypeScript
0 vote122 views1 answer
Wordpress posts sidebar with category link programmatically
TypeScript