在onOpen条目对象中为函数添加参数 [英] Adding arguments to a function in the onOpen entries object
本文介绍了在onOpen条目对象中为函数添加参数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
有没有办法将参数添加到将添加到Google Spreadsheet文档的Script Center菜单中的功能?这是普通的onOpen方法。
Is there are a way I can add arguments to a function that will be added to the Script Center Menu on a Google Spreadsheet document? This is the normal onOpen method.
function onOpen() {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
var entries = [{
name : "Summary",
functionName : "myOnOpen"
}
];
sheet.addMenu("Script Center Menu", entries);
};
我想知道是否有类似于以下的内容。
I was wondering if there is something similar to the following.
function onOpen() {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
var entries = [{
name : "Summary",
functionName : "myOnOpen",
arguments : [value: "Some value"]
}
];
sheet.addMenu("Script Center Menu", entries);
};
谢谢!
Thanks!
推荐答案
我认为这完全不可能和你写的一样,但你可以用下面的方式来完成:
I don't think that is possible exactly as you have written, but you can do it in the following way:
function onOpen() {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
var entries = [{
name : "Summary",
functionName : "myParameterisedOpen",
}
];
sheet.addMenu("Script Center Menu", entries);
};
function myParameterisedOpen() {
myOnOpen("Some value");
};
这篇关于在onOpen条目对象中为函数添加参数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文