/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

4 votes117 views1 answer
Typescript string interpolation
TypeScript
0 vote112 views1 answer
Difference in minutes between 2 time inputs laravel
TypeScript
0 vote104 views1 answer
Plot 3d points in python
TypeScript
0 vote111 views1 answer
Chevrons or angle brackets latex
TypeScript
1 vote108 views2 answers
How to remove last 2 elements from list in python
TypeScript
0 vote109 views1 answer
How to use array pop in typescript
TypeScript
1 vote106 views6 answers
Could not find a declaration file for module implicitly has an 'any' type.
TypeScript
0 vote148 views1 answer
Typescript window ethereum
TypeScript
1 vote107 views1 answer
Set element disable in typescript
TypeScript
0 vote134 views1 answer
Show that the speed of the spacecraft in its orbit is 3.7 × 103ms –1.
TypeScript