lwc:programming:googlescripts

This is an old revision of the document!


function mainDeal() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sourceSheet = getSheetByGid(ss, 1330911434);
}
function getSheetByGid(spreadsheet, gid){
    gid = +gid || 0;
    var res_ = undefined;
    var sheets_ = spreadsheet.getSheets();
    for(var i = sheets_.length; i--; ){
        if(sheets_[i].getSheetId() === gid){
            res_ = sheets_[i];
            break;
        }
    }
    return res_;
}
  • lwc/programming/googlescripts.1612213784.txt.gz
  • Last modified: 2021/02/01 15:09
  • by John Harrison