// Adding a menu through UI
var ui = SpreadsheetApp.getUi();
var custommenu = ui.createMenu('My Shortcut Menu')
var menuitem = data_range.getCell(walkrow, walkcol).getValue();
var menufunction = data_range.getCell(walkrow, 2).getValue();
for ( ; walkrow <= rowcount; walkrow++ ) {
menuitem = data_range.getCell(walkrow, walkcol).getValue();
menufunction = data_range.getCell(walkrow, 2).getValue();
custommenu.addItem(menuitem, menufunction);
custommenu.addSeparator();
Logger.log("menu item name is " + menuitem + " and function name is " +menufunction);
}
Logger.log("*******");
custommenu.addToUi();
1 回答
不确定这是你在寻找什么,但是以编程方式创建菜单项,你会使用类似这样的代码:
其中data_range是一个范围,walkrow和walkcol是有效的计数器等 .