我对此非常陌生,还没有找到一个对我有意义的解决方案,当我试图在当前的Google工作表上运行此函数时,我仍然收到错误,“请先选择一个活动工作表”,但我已经在下面的函数中针对该工作表,对吗?如果有人能对我做错了什么提供深刻的见解,我将不胜感激。
function onOpen() {
var ui = SpreadsheetApp.getUi();
ui.createMenu("MAH MENU").addItem("TEST", "crawlOnEm").addToUi();
}
function crawlOnEm() {
var ui = SpreadsheetApp.getUi();
var activeSheet = SpreadsheetApp.getActiveSpreadsheet();
var selection = activeSheet.getSelection().getCurrentCell();
var row = selection.getRow();
var column = selection.getColumn();
var sheetWeCareAbout = activeSheet.getSheetByName("Week-by-week");
var walkingRange = sheetWeCareAbout.getRange(row, 1);
var walkingRow = row;
while(walkingRange.getBackground() !== "#efefef" && walkingRow >= 1) {
walkingRange = sheetWeCareAbout.getRange(walkingRow, 1);
walkingRow++;
}
ui.alert("Date is: " + walkingRange.getValue());
}
发布于 2018-06-20 05:54:41
很可能是activeSheet.getSheetByName("Week-by-week")
返回了null
。仔细检查是否有一个名为Week-by-week
的工作表。
https://stackoverflow.com/questions/50936476
复制相似问题