我在此脚本上做错了什么?它说“在对象Spreadsheet中找不到函数createMenu". [英] What did I do wrong on this script? It says "Cannot find function createMenu in object Spreadsheet."

问题描述

我做错了什么?

function onInstall() {
    onOpen();
function onOpen(e) {
    SpreadsheetApp.getActive()
        .createMenu('Sentrix Messaging')
        .addItem('Index', 'new mail')
        .addItem('Compose', 'Write mail')
        .addToUi();
    Browser.msgBox('Welcome to Sentrix Email');
    ShowSidebar();
}

function showSidebar() {
    var html = HtmlService.createTemplateFromFile("Inbox")
        .evaluate()
        .setTitle("Email");
    SpreadsheetApp.getUi().showSidebar(html);
}
}

说

在对象电子表格中找不到函数createMenu

Cannot find function createMenu in object Spreadsheet

推荐答案

我认为您在括号中输入了错误.

I think you made a mistake with brackets.

function onInstall() {
    onOpen();
}
function onOpen(e) {
    SpreadsheetApp.getActive()
        .createMenu('Sentrix Messaging')
        .addItem('Index', 'new mail')
        .addItem('Compose', 'Write mail')
        .addToUi();
    Browser.msgBox('Welcome to Sentrix Email');
    ShowSidebar();
}

function showSidebar() {
    var html = HtmlService.createTemplateFromFile("Inbox")
        .evaluate()
        .setTitle("Email");
    SpreadsheetApp.getUi().showSidebar(html);
}

这篇关于我在此脚本上做错了什么?它说“在对象Spreadsheet中找不到函数createMenu".的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！