/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 vote190 views1 answer
Powershell see ports in use
TypeScript
0 vote193 views2 answers
Npm clean
TypeScript
2 votes197 views2 answers
File_check.ps1 cannot be loaded because running scripts is disabled on this system.
TypeScript
1 vote181 views1 answer
Use map with filter in react components from arrays of data
TypeScript
0 vote204 views1 answer
Listen to hub events asw analytics
TypeScript
0 vote188 views1 answer
Cannot find module '@tns-core-modules/application-settings' or its corresponding type declarations.
TypeScript
-1 vote197 views1 answer
Nest custom class validator
TypeScript
1 vote191 views1 answer
Retrieve data from firebase flutter
TypeScript
0 vote188 views1 answer
Algorithm that prints if one of the numbers is multiple of the other
TypeScript
49 votes189 views5 answers
How to remove bullets from ul
TypeScript