Google 表格宏清单资源
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
用于定义
Google 表格宏的配置。定义宏的清单必须包含所有标记为必需的字段。
表格
Google 表格宏清单配置的顶级元素。此属性仅用于定义 Google 表格宏。
| JSON 表示法 |
{
"macros": [
{
object (Macro)
}
]
} |
| 字段 |
macros[] |
object (Macro)
必需。已定义宏及其关联属性的列表。
|
宏
单个宏的配置。定义必须包含所有标记为必需的字段。
| JSON 表示法 |
{
"defaultShortcut": string,
"functionName": string,
"menuName": string
} |
| 字段 |
defaultShortcut |
string
定义执行宏的键盘快捷键。
此值必须采用 Ctrl+Alt+Shift+Number 格式，其中 Number 是一个单数位。没有快捷键的宏只能通过工具 > 宏菜单执行。
|
functionName |
string
必需。执行宏的 Apps 脚本函数的名称。默认情况下，此值与自动创建的函数的 menuName 相匹配，但这不是必需的。
|
如未另行说明，那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可，并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情，请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
最后更新时间 (UTC)：2025-08-31。
[null,null,["最后更新时间 (UTC)：2025-08-31。"],[[["\u003cp\u003eSheets macros are defined using a manifest configuration, which must include all required fields.\u003c/p\u003e\n"],["\u003cp\u003eEach macro definition specifies a keyboard shortcut, the name of the Apps Script function to execute, and the menu name displayed in the Google Sheets UI.\u003c/p\u003e\n"],["\u003cp\u003eThe keyboard shortcut must be unique and follow the format \u003ccode\u003eCtrl+Alt+Shift+\u003c/code\u003e followed by a single digit.\u003c/p\u003e\n"],["\u003cp\u003eMacros without assigned shortcuts can only be run from the \u003cstrong\u003eTools > Macros\u003c/strong\u003e menu in Google Sheets.\u003c/p\u003e\n"]]],[],null,["# Sheets macro manifest resource\n\nThe configuration that is used to define\n[Sheets macros](/apps-script/guides/sheets/macros#manifest_structure_for_macros). Manifests that define macros must have all the fields\nmarked as **Required**.\n\nSheets\n------\n\nThe top-level of the Sheets macro manifest configuration. This is only\nused to define Sheets macros.\n\n| JSON representation |\n|--------------------------------------------------|\n| ```text { \"macros\": [ { object (Macro) } ] } ``` |\n\n| Fields ||\n|------------|------------------------------------------------------------------------------------------------------|\n| `macros[]` | `object (`[Macro](#macro)`)` **Required.** A list of defined macros and their associated properties. |\n\n### Macro\n\nThe configuration for a single macro. The definition must have all the fields\nmarked as **Required**.\n\n| JSON representation |\n|---------------------------------------------------------------------------------------|\n| ```text { \"defaultShortcut\": string, \"functionName\": string, \"menuName\": string } ``` |\n\n| Fields ||\n|-------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| `defaultShortcut` | `string` Defines the keyboard shortcut that executes the macro. This **must** be of the form `Ctrl+Alt+Shift+`*Number*, where *Number* is a single-digit. Macros without shortcuts can only be executed from the **Tools \\\u003e Macros** menu. | **Warning**: the keyboard shortcut used by each defined macro must be unique. |\n| `functionName` | `string` **Required.** The name of the Apps Script function that executes the macro. By default this matches the `menuName` for functions automatically created, but this is not a requirement. |\n| `menuName` | `string` **Required.** The name of the macro as it appears in the Google Sheets UI. |"]]
