/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

5 votes206 views3 answers
Intersection python
TypeScript
0 vote205 views1 answer
Ts in r
TypeScript
0 vote263 views1 answer
Difference between facets and filters algolia
TypeScript
0 vote211 views2 answers
Python requests get all cookies
TypeScript
3 votes193 views1 answer
Squash commits in remote branch
TypeScript
1 vote190 views2 answers
Adjust distance of subplots in python
TypeScript
0 vote194 views1 answer
Angular elementref parent
TypeScript
0 vote174 views1 answer
Typescript event emitter
TypeScript
0 vote215 views1 answer
Who indirectly elects the president
TypeScript
11 votes153 views1 answer
Check open ports windows
TypeScript