/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

2 votes197 views2 answers
How to get the elements that missing in other tables sql
TypeScript
1 vote215 views1 answer
Check if file.properties is exits android
TypeScript
0 vote187 views1 answer
Testing with limited information
TypeScript
5 votes187 views1 answer
Vscode change comments color
TypeScript
0 vote206 views1 answer
Typescript instantiate 2d array
TypeScript
0 vote196 views1 answer
Angular/RxJs When should I unsubscribe from `Subscription`
TypeScript
0 vote197 views1 answer
Sum of bits calculator
TypeScript
0 vote194 views1 answer
How to check git folder exists or not
TypeScript
1 vote196 views1 answer
Challenges in agile
TypeScript
0 vote191 views1 answer
Replace element in array typescript
TypeScript