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:

Generate QR Code in MS Word

Press CTRL + F9 Inside the braces, type: {displaybarcode”your-website.domain”qr\q3} Press ALT + F9 to generate the QR code