我有一個 main 函數,它執行一系列操作,并將輸出與在各個變量中聲明的其他多個值一起推送到數組中。然后我需要將它們傳遞給另一個子函數以進行其他一系列操作,然后返回更新后的數組。我意識到,如果我只傳遞數組名稱,就像我將單個變量作為參數傳遞給另一個函數一樣,它是行不通的。function mainfn(){var sheet=SpreadsheetApp.openById("THIS_SHEET_ID").getSheetByName("wshop");var sheetdata=sheet.getDataRange().getValues();var lrow=sheet.getLastRow();var var1=sheetdata[lrow-1][2];var var2=sheetdata[lrow-1][3];var arr1=[],arr2=[];//some operationsAarr1.push(1,"str1","3%",5,6,"str2"); //output OpsA being stored in array named arr1//some operationsBarr2.push(3,5,6,8,0,1); //output OpsB being stored in array named arr2mysubfunction(var1,var2,arr1,arr2); // calling subfunction and passing argumentsvar arr3=[],var arr4=[];var arr3=mysubfunction()[0]; // supposedly getting the arr1 updated elements and put into arr3var arr4=mysubfunction()[1]; // supposedly getting the arr2 updated elements and put into arr4// do some other stuff over the array elements}function mysubfunction(var1,var2,arr1,arr2){//some operationsC that updates the elements in both arraysvar result=[arr1,arr2];return result;}請幫助更正我關于傳遞和返回多個數組的代碼。謝謝
如何將多個數組和單個 arg 的混合傳遞給另一個函數并返回它們(GAS/JS)?
ABOUTYOU
2023-05-19 19:50:37