如何使用 'i' 遍歷作業表索引號？
我試過這個：
function myFunction() {
for (var i = 2; i < 14; i );{
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getSheets()[i].getRange('J10').setFormula('=iferror(VLOOKUP($B9,\'STUDENT SCORES\'!AL46:AM49,2,FALSE)," ")');
}
}
但它不起作用。
謝謝您的幫助！
uj5u.com熱心網友回復：
使用此示例腳本：-
function myFunction() {
var spreadsheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
for (var i = 2; i < spreadsheets.length; i );{
spreadsheets[i].getRange('J10')
.setFormula('=iferror(VLOOKUP($B9,\'STUDENT SCORES\'!AL46:AM49,2,FALSE)," ")');
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/453682.html