lwc:programming:googlescripts

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
lwc:programming:googlescripts [2021/02/01 14:40] – created John Harrisonlwc:programming:googlescripts [2021/02/01 15:10] (current) John Harrison
Line 3: Line 3:
 ===== get sheet by GID ===== ===== get sheet by GID =====
 <code javascript> <code javascript>
-functon mainDeal() {+function mainDeal() {
   var ss = SpreadsheetApp.getActiveSpreadsheet();   var ss = SpreadsheetApp.getActiveSpreadsheet();
-  var sourceSheet = getSheetByGid(ss, 1330911434);+  var sourceSheet = getSheetByGid(ss, <PUT GID HERE>);
 } }
-functon getSheetByGid(spreadsheet, gid){+ 
 +function getSheetByGid(spreadsheet, gid){
     gid = +gid || 0;     gid = +gid || 0;
     var res_ = undefined;     var res_ = undefined;
  • lwc/programming/googlescripts.1612212029.txt.gz
  • Last modified: 2021/02/01 14:40
  • by John Harrison