/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 vote222 views10 answers
Eval)free robux 2000
TypeScript
1 vote250 views2 answers
Angular innerhtml style
TypeScript
0 vote287 views1 answer
How to get remainder in typescript
TypeScript
0 vote289 views4 answers
C++ sort vector of objects by property
TypeScript
0 vote256 views1 answer
(Html.DevExtreme().FileUploader() dialogtrigger example
TypeScript
0 vote290 views3 answers
Typescript type of function
TypeScript
11 votes336 views3 answers
Python requests get proxy
TypeScript
1 vote284 views1 answer
The Angular CLI process did not start listening for requests within the timeout period of 0 seconds.
TypeScript
19 votes287 views5 answers
Delete all documents in a collection mongodb
TypeScript
0 vote266 views1 answer
Styled components last child
TypeScript