当尝试将值存储在全局数组“ dataToGlobalArray”中时,我似乎无法。
当尝试打印全局数组的内容时,在函数“ printGlobalArrayData”中,我得到一个空字符串。可能是什么问题?
代码如下:
var dataToGlobalArray = [];
function myFunction(){
dataToGlobalArray = [];
var ss=Spreadsheetapp.getactiveSpreadsheet().getactiveSheet();
var ss2=Spreadsheetapp.getactive().getSheetByName('Other_Updates')
var dataToArray= [];
/* Loops through the list and adds values to an Array,to be ready to be added to the designated sheet. It adds values that are non-blank */
for (i=62; i<73; i++){
var valuesToBeCopied = ss2.getRange(i,1).getvalue();
if (valuesToBeCopied!=""){
dataToGlobalArray.push(valuesToBeCopied);
}
}
dataToGlobalArray.push(dataToArray);
}
function printGlobalArrayData(){
Logger.log(dataToGlobalArray)
}