/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 vote240 views1 answer
Three requirements for laser action
TypeScript
0 vote233 views1 answer
Error on indexing the object in ts
TypeScript
0 vote255 views1 answer
Typescript not supporting scss
TypeScript
0 vote256 views1 answer
Array of objects for in
TypeScript
0 vote244 views1 answer
Generics in arrow function
TypeScript
0 vote206 views1 answer
Amcharts angular
TypeScript
0 vote236 views1 answer
Give all element in a list starts with string
TypeScript
0 vote240 views1 answer
Pcmanfm ubuntu
TypeScript
0 vote244 views1 answer
What kind of projects is suitable for the Agile methodology
TypeScript
0 vote249 views1 answer
How to know if window exists in nodejs
TypeScript