這是我的代碼片段作業：
function loadBusinessProposalData () {
var sourceSheet = SpreadsheetApp.openById(idSS).getSheetByName("dctPro");
var pasteSheet = SpreadsheetApp.openById(idSS).getSheetByName("Gerar");
var source = sourceSheet.getRange(2,3,1,sourceSheet.getLastColumn() - 2);
const valuesToPaste = source.getValues();
generateReferenceCellMap();
for (let i = 0; i < valuesToPaste[0].length; i ) {
var destination = pasteSheet.setActiveSelection(referenceCells[i]);
destination.setValue(valuesToPaste[0][i]);
//if (i = 129) {
// console.log(i); //for test
// Utilities.sleep(1500);
//}
}
function generateReferenceCellMap () {
var referenceSheet = SpreadsheetApp.openById(idSS).getSheetByName("dcPro");
var referenceRange = referenceSheet.getRange(2,3,1, referenceSheet.getLastColumn() - 2);
var referenceFormulas = referenceRange.getFormulas();
for (let i = 0; i < referenceFormulas[0].length; i ) {
var reference = getCellReferenceByFormulaReference(referenceFormulas[0][i]);
referenceCells.push(reference);
}
}
function getCellReferenceByFormulaReference(formulaReference) {
var delimiterSheetPosition = formulaReference.indexOf("!");
var cellReference = formulaReference.slice(delimiterSheetPosition 1);
return cellReference;
//console.log(cellReference);
}
但是我需要在 for 回圈中間強制等待公式在作業表中更新，這樣我就可以繼續 for 回圈并更改其他單元格。
我已經嘗試過這種方式：
for (let i = 0; i < valuesToPaste[0].length; i ) {
var destination = pasteSheet.setActiveSelection(referenceCells[i]);
destination.setValue(valuesToPaste[0][i]);
if (i = 129) {
console.log(i); //for test
Utilities.sleep(1500);
}
}
因此：
for (let i = 0; i < valuesToPaste[0].length; i ) {
var destination = pasteSheet.setActiveSelection(referenceCells[i]);
destination.setValue(valuesToPaste[0][i]);
if (i = 129) {
console.log(i); //for test
SpreadsheetApp.flush();
}
}
因此：
for (let i = 0; i < valuesToPaste[0].length; i ) {
var destination = pasteSheet.setActiveSelection(referenceCells[i]);
destination.setValue(valuesToPaste[0][i]);
if (i = 129) {
console.log(i); //for test
Utilities.sleep(1500);
SpreadsheetApp.flush();
}
}
但在所有方面顯然變數 i 停止遞增，并且腳本回圈
你能幫我理解為什么會這樣嗎？
謝謝。
uj5u.com熱心網友回復：
這if (i = 129)應該是這個if (i == 129)或可能是這個if (i === 129)
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/522957.html
標籤：谷歌应用脚本谷歌表格