Thursday, 4 December 2025

Using JS in GoogleSheets

function func() 
{
    // sheet initial
    var app= SpreadsheetApp;
    var activeSheet = app.getActiveSpreadsheet().getActiveSheet();

    // get value
    var cell = activeSheet.getRange(row, col).getValue();

    // set value
    activeSheet.getRange(row, col).setValue(cell);

    // console log
    Logger.log (cell);
}

No comments:

Using JS in GoogleSheets

function func()  {      // sheet initial      var app= SpreadsheetApp;      var activeSheet = app.getActiveSpreadsheet().getActiveSheet();  ...