/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 votes192 views1 answer
Cannot find module 'next' or its corresponding type declarations.
TypeScript
2 votes225 views5 answers
Plot multiple plots in r
TypeScript
0 vote195 views1 answer
How does the biological aspect of mountain region depend upon its physical aspect
TypeScript
1 vote225 views3 answers
Where do you get your test data
TypeScript
0 vote184 views1 answer
Is missing in props validation typescript
TypeScript
0 vote247 views1 answer
Minimum number of cycle shifts for each string if it can be made palindrome
TypeScript
0 vote186 views1 answer
Parameter 'props' implicitly has an 'any' type.ts
TypeScript
0 vote195 views1 answer
Increase space between border dots css
TypeScript
0 vote191 views1 answer
Separate subplots in python
TypeScript
0 vote197 views3 answers
Convert typescript to js online
TypeScript