/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

1 vote386 views1 answer
List open ports firewalld
TypeScript
1 vote346 views1 answer
CLIENT MISSING INTENTS discord
TypeScript
0 vote312 views1 answer
O arquivo yarn.ps1 não pode ser carregado porque a execução de scripts foi desabilitada neste sistema
TypeScript
0 vote362 views1 answer
Claire betts facebook
TypeScript
-1 vote255 views1 answer
Angular events list
TypeScript
2 votes329 views3 answers
Angular set url parameters
TypeScript
11 votes396 views3 answers
Python requests get proxy
TypeScript
0 vote328 views1 answer
Execute script when c# code gets executed
TypeScript
1 vote318 views1 answer
Nmap to find open ports kali linux
TypeScript
0 vote303 views1 answer
Number of elements in circular queue
TypeScript