問題描述

• 我的公司使用 Google 云端硬盤來存儲其文檔等.
• 我們通過將 Google 產品數據文件加載到電子表格中來搜索我公司的 Google 產品數據文件，但 ImportXML 并不能滿足我們的所有需求.
• 因此，我制作了一個簡單的 Google Apps 腳本文件來處理數據，并將其輸出到打開的電子表格中當前活動的跨頁.
• 機制由 UI 菜單/模式組合控制.

• 我一直在開發它作為附加到電子表格的腳本，但現在我想讓其他有權訪問 Google 云端硬盤的人使用它.

• 如何分發此腳本，并在有人加載新的 Google Sheet 文檔時讓它運行 onOpen()?
• 我只想將腳本存儲在公司范圍內的 Google Drive 上，讓人們安裝"它或其他東西，然后通過菜單 UI 運行它.
• 理想情況下，這意味著我可以隨時調整腳本，因為人們從同一來源加載腳本.

我唯一的解決方案真的是讓人們將代碼復制粘貼到他們自己文檔的腳本編輯器中，然后手動運行 onOpen() 嗎?(根本無法維護 + 難以教授).

Is my only solution really getting people to copy-paste the code into their own documents' Scripts Editor, and run onOpen() manually? (Not at all maintainable + hard to teach).

推薦答案

如果您的組織使用 G Suite 帳戶，則域管理員可以在域范圍內"安裝插件.

If your organization is using a G Suite account, an add-on can be installed "domain wide" by the domain administrator.

要了解您的域管理員是誰，請使用以下鏈接:

To find out who your domain administrator is, use the following link:

https://support.google.com/a/answer/6208960

域范圍的安裝與在其用戶帳戶中安裝插件的個人之間存在差異.

There is a difference between domain wide installation, and an individual installing an add-on in their user account.

要在域范圍內安裝插件，域管理員必須登錄，并以域管理員的身份以身份安裝插件.首先，域管理員必須打開管理控制臺.

For the add-on to be installed domain wide, the domain administrator must be signed in, and install the add-on as the domain administrator. First the domain administrator must open the admin console.

要登錄 G Suite 管理員主頁，請使用以下鏈接:

To log into the G Suite admin home page use the link:

https://admin.google.com/AdminHome

管理員必須導航到 G Suite Marketplace，找到插件并安裝它.

The administrator must navigate to the G Suite Marketplace, find the add-on, and install it.

在安裝插件之前，管理員必須從 G Suite Marketplace 啟用 Google 插件，或者如果您不想允許安裝所有插件，則將特定插件列入白名單.

Before an add-on can be installed, the Administrator must either enable Google add-ons from the G Suite Marketplace, or whitelist a specific add-on if you don't want to allow all add-ons to be installed.

從管理主頁導航:

• 應用程序
• G 套件
• 云端硬盤和文檔
• 功能和應用
• 附加組件
• 開啟

如果插件安裝通常受到限制，則可以將特定插件列入白名單.為了將插件列入白名單，管理員需要插件腳本的 App ID.腳本的 App ID 必須由腳本的所有者提供.

A specific Add-on can be whitelisted if add-on installation has been restricted in general. In order to whitelist an add-on the administrator will need the App ID of the add-on script. The App ID of a script must be provided by the owner of the script.

請注意，此處提供的域范圍安裝說明假定插件已發布到 G Suite Marketplace.文檔中解釋了如何為 G Suite Marketplace 驗證和批準插件.

Note that the instructions provided here for domain wide installation, assume that the add-on is already published to the G Suite Marketplace. Getting an add-on verified and approved for the G Suite Marketplace is explained in the documentation.

申請發布

安裝 Marketplace 應用控制 Marketplace 應用的用戶安裝

附加組件的替代方案是庫:

An alternative to an add-on is a library:

想要使用該庫的用戶需要進行一些安裝.他們需要從電子表格中打開 Apps 腳本代碼編輯器，然后輸入庫密鑰.

The users who want to use the library need to do some installation. They would need to open the Apps Script code editor from the spreadsheet, and enter the library key.

文檔 - 庫

Apps Script API 可用于創建新項目(腳本)文件并覆蓋現有項目文件.但問題是，腳本需要綁定到工作表，并且目前沒有以編程方式獲取綁定到工作表的項目的腳本 ID 的方法.(如果這發生了變化，并且您注意到了，請發表評論以更新答案)如果您知道綁定到工作表的項目 ID，那么您可以使用 Apps Script API 覆蓋腳本文件，或者您可以以編程方式更新項目文件的 appsscript.json 文件中的庫版本號.這將提供一種將綁定腳本部署到工作表文件或更新庫版本號的方法.您可以手動獲取和保存哪些腳本 ID 綁定到哪些表格文件，然后使用 Apps 腳本 API 覆蓋項目文件.用戶需要創建一個綁定到工作表的腳本，然后提供項目文件 ID，或者用戶可以復制模板工作表的文件并綁定腳本.

The Apps Script API can be used to create new project (script) files and overwrite existing project files. But the problem is, that the script would need to be bound to the Sheet, and there is no current way to programmatically get the script ID of projects bound to Sheets. (If this changes, and you notice, then make a comment to update the answer) If you know the project ID that is bound to the Sheet, then you could use the Apps Script API to overwrite the script file, or you could programatically update the library version number in the project file's appsscript.json file. That would provide a way to deploy bound scripts to Sheet's files, or update library version numbers. You could manually get and save which script IDs were bound to what Sheets files, and then use the Apps Script API to overwrite the project file. The user would either need to create a script that was bound to the Sheet, and then provide the project file ID, or the user could copy a template Sheet's file with a script bound to it.

這篇關于在您的公司網絡中分發適用于表格的 Google Apps 腳本的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！