在 Excel 之外的浏览器中从 Ribbon 中的按钮直接打开网页?

问题描述：

我们在 AppSource 中有几个 Excel 插件.目前，我们在功能区中有一个用于 Documentation 的按钮，单击该按钮可在 Excel 的任务窗格中打开文档网页.

We have several Excel add-ins in AppSource. At the moment, we have a button in Ribbon for Documentation, clicking on the button opens the documentation webpage in a taskpane in Excel.

我们觉得由于任务面板很小，人们不太可能阅读那里的文档.因此，更好的方法是在 Excel 之外的浏览器中打开文档网页.

We feel that as the taskpane is small, people are unlikely to read documentation over there. So a better way would be to open the documentation webpage in a browser outside Excel.

我们注意到在 Script Lab 中，点击 Reference Docs 会打开一个小窗口，其中包含 在新窗口中打开链接.然后，我们需要点击该链接以最终在浏览器中打开它:

We notice that in Script Lab, clicking on the Reference Docs opens a small window which contains open link in new window. Then, we need to click on that link to finally open that in a browser:

https://user-images.githubusercontent.com/774409/81099107-ab068e80-8f0a-11ea-9633-eba5c1e42f90.png

那么我们必须要有这个中间窗口吗?我们不能在 Excel 之外的浏览器中通过 Ribbon 中的按钮直接打开网页吗?

So do we have to have this intermediate window? Cannot we open directly a web page from a button in Ribbon in a browser outside Excel?

PS:我不想用Dialog API来显示文档，因为Dialog窗口打开的时候好像不能同时使用Excel?

PS: I don't want to use Dialog API to show documentation, because it seems that when the Dialog window is open, we cannot use Excel at the same time?

答

在清单中，您可以减少 UI，并指定加载项通过执行 JavaScript 的加载项命令公开的操作的源代码文件功能而不是显示 UI，

In manifest, you could make it UI less, and specifies the source code file for operations that an add-in exposes through add-in commands that execute a JavaScript function instead of displaying UI，

<DesktopFormFactor>
  <FunctionFile resid="residDesktopFuncUrl" />
  <ExtensionPoint xsi:type="PrimaryCommandSurface">
    <!-- information about this extension point -->
  </ExtensionPoint>        
</DesktopFormFactor>

并且在FunctionFile中你可以添加一个函数，它可以调用Office.context.ui.openBrowserWindow(url)在excel之外的默认浏览器中启动URL

and in the FunctionFile you could add a function, which can call Office.context.ui.openBrowserWindow(url) to launch the URL in the default browser outside of excel

Office.context.ui.openBrowserWindow("https://github.com");

可以在此处找到该文档，描述了如何实现manifest中FunctionName定义的函数.

The document can be found at here, which describes how to implement the function defined by FunctionName in the manifest.

在 Excel 之外的浏览器中从 Ribbon 中的按钮直接打开网页?

相关推荐