/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 votes107 views2 answers
Change url param angular
TypeScript
1 vote136 views1 answer
Header imitate python
TypeScript
0 vote150 views1 answer
Write a C proogram to find the roots of quadratic equation
TypeScript
0 vote132 views1 answer
Connect onboarding for custom accounts specify country
TypeScript
0 vote134 views1 answer
Number of increments and decrements to make array sorted
TypeScript
0 vote123 views1 answer
C# get amount of elements in enum
TypeScript
0 vote114 views1 answer
How many arguments does a call to the Math.sqrt method have?
TypeScript
1 vote116 views1 answer
"send" and "transfer" are only available for objects of type "address payable", not "address".
TypeScript
2 votes136 views2 answers
Cannot use JSX unless the '--jsx' flag is provided.ts(17004)
TypeScript
0 vote129 views2 answers
Can subclass method infere exceptions of its superclass method
TypeScript