Microsoft Excel Mac Add Ins

03.04.2020 admin

Microsoft Excel Mac Add Ins Account
Microsoft Excel Add Ins

-->

An Excel add-in allows you to extend Excel application functionality across multiple platforms including Windows, Mac, iPad, and in a browser. Use Excel add-ins within a workbook to:

Add-ins provide optional commands and features for Microsoft Excel. By default, add-ins are not immediately available in Excel, so you must first install and (in some cases) activate these add-ins so that you can use them. Some add-ins are built in to Excel, such as Solver and the Analysis ToolPak. Some other add-ins are available from the Download Center, and must first be downloaded. 2019-12-21 Click on the drop-down arrow next to My Add-ins and select your Excel add-in. Your Excel add-in will now load and a callout will be displayed. Click on the Got it button to dispose the callout. Click on your Excel add-in button to sideload the add-in. Sideload Office Add-ins on iPad and Mac. 2020-2-13 Office Add-ins run in Office on the web, Windows, Mac, and iPad. 集中部署和分发：管理员可以在整个组织内集中部署 Office 加载项。Centralized deployment and distribution. Admins can deploy Office Add-ins centrally across an organization.

Interact with Excel objects, read and write Excel data.
Extend functionality using web based task pane or content pane
Add custom ribbon buttons or contextual menu items
Add custom functions
Provide richer interaction using dialog window

The Office Add-ins platform provides the framework and Office.js JavaScript APIs that enable you to create and run Excel add-ins. By using the Office Add-ins platform to create your Excel add-in, you'll get the following benefits:

Cross-platform support: Excel add-ins run in Office on the web, Windows, Mac, and iPad.
Centralized deployment: Admins can quickly and easily deploy Excel add-ins to users throughout an organization.
Use of standard web technology: Create your Excel add-in using familiar web technologies such as HTML, CSS, and JavaScript.
Distribution via AppSource: Share your Excel add-in with a broad audience by publishing it to AppSource.

Note

Excel add-ins are different from COM and VSTO add-ins, which are earlier Office integration solutions that run only in Office on Windows. Unlike COM add-ins, Excel add-ins do not require you to install any code on a user's device, or within Excel.

Components of an Excel add-in

An Excel add-in includes two basic components: a web application and a configuration file, called a manifest file.

The web application uses the Office JavaScript API to interact with objects in Excel, and can also facilitate interaction with online resources. For example, an add-in can perform any of the following tasks:

Create, read, update, and delete data in the workbook (worksheets, ranges, tables, charts, named items, and more).
Perform user authorization with an online service by using the standard OAuth 2.0 flow.
Issue API requests to Microsoft Graph or any other API.

The web application can be hosted on any web server, and can be built using client-side frameworks (such as Angular, React, jQuery) or server-side technologies (such as ASP.NET, Node.js, PHP).

The manifest is an XML configuration file that defines how the add-in integrates with Office clients by specifying settings and capabilities such as:

The URL of the add-in's web application.
The add-in's display name, description, ID, version, and default locale.
How the add-in integrates with Excel, including any custom UI that the add-in creates (ribbon buttons, context menus, and so on).
Permissions that the add-in requires, such as reading and writing to the document.

To enable end users to install and use an Excel add-in, you must publish its manifest either to AppSource or to an add-ins catalog. For details about publishing to AppSource, see Make your solutions available in AppSource and within Office.

Capabilities of an Excel add-in

In addition to interacting with the content in the workbook, Excel add-ins can add custom ribbon buttons or menu commands, insert task panes, add custom functions, open dialog boxes, and even embed rich, web-based objects such as charts or interactive visualizations within a worksheet.

Add-in commands

Add-in commands are UI elements that extend the Excel UI and start actions in your add-in. You can use add-in commands to add a button on the ribbon or an item to a context menu in Excel. When users select an add-in command, they initiate actions such as running JavaScript code, or showing a page of the add-in in a task pane.

Add-in commands

For more information about command capabilities, supported platforms, and best practices for developing add-in commands, see Add-in commands for Excel, Word, and PowerPoint.

Task panes

Task panes are interface surfaces that typically appear on the right side of the window within Excel. Task panes give users access to interface controls that run code to modify the Excel document or display data from a data source.

Task pane

For more information about task panes, see Task panes in Office Add-ins. For a sample that implements a task pane in Excel, see Excel Add-in JS WoodGrove Expense Trends.

Custom functions

Custom functions enable developers to add new functions to Excel by defining those functions in JavaScript as part of an add-in. Users within Excel can access custom functions just as they would any native function in Excel, such as SUM().

Custom function

For more information about custom functions, see Create custom functions in Excel.

Dialog boxes

Dialog boxes are surfaces that float above the active Excel application window. You can use dialog boxes for tasks such as displaying sign-in pages that can't be opened directly in a task pane, requesting that the user confirm an action, or hosting videos that might be too small if confined to a task pane. To open dialog boxes in your Excel add-in, use the Dialog API.

Dialog box

For more information about dialog boxes and the Dialog API, see Dialog boxes in Office Add-ins and Use the Dialog API in your Office Add-ins.

Content add-ins

Content add-ins are surfaces that you can embed directly into Excel documents. You can use content add-ins to embed rich, web-based objects such as charts, data visualizations, or media into a worksheet or to give users access to interface controls that run code to modify the Excel document or display data from a data source. Use content add-ins when you want to embed functionality directly into the document.

Content add-in

For more information about content add-ins, see Content Office Add-ins. For a sample that implements a content add-in in Excel, see Excel Content Add-in Humongous Insurance in GitHub.

Office 365 customers get the new Office for Mac first. You’ll have Office applications on your Mac or PC, apps on tablets and smartphones for when you're on the. Microsoft Office Mac 破解版是一款 Mac Office 办公软件。包含了 Word、Excel、PowerPoint、Outlook、OneNote 等组件，本站提供 Office Mac 破解版下载，Office Mac 安装破解激活教程；. Office 365 的 Office for Mac，让你能从几乎任何地方灵活地完成工作。找到适合你的 Office。快速开始使用 Word、Excel、PowerPoint、Outlook 和 OneNote 的全新新式版本 - 结合了你喜爱的 Office 熟悉功能和.

JavaScript APIs to interact with workbook content

An Excel add-in interacts with objects in Excel by using the Office JavaScript API, which includes two JavaScript object models:

Excel JavaScript API: Introduced with Office 2016, the Excel JavaScript API provides strongly-typed Excel objects that you can use to access worksheets, ranges, tables, charts, and more.
Common API: Introduced with Office 2013, the Common API enables you to access features such as UI, dialogs, and client settings that are common across multiple types of Office applications. Because the Common API does provide limited functionality for Excel interaction, you can use it if your add-in needs to run on Excel 2013.

Next steps

Get started by creating your first Excel add-in. Then, learn about the core concepts of building Excel add-ins.

Office 加载项与 COM 和 VSTO 加载项有何不同？How are Office Add-ins different from COM and VSTO add-ins?

COM 或 VSTO 加载项是旧 Office 集成解决方案，仅在 Windows 版 Office 上运行。与 COM 加载项不同，Office 加载项不涉及在用户设备或 Office 客户端中运行的代码。对于 Office 加载项，主机应用程序（例如 Excel）会读取加载项清单，并挂钩 UI 中的加载项自定义功能区按钮和菜单命令。如果需要，它加载加载项的 JavaScript 和 HTML 代码，此代码在沙盒中的浏览器上下文范围内执行。COM or VSTO add-ins are earlier Office integration solutions that run only on Office on Windows. Unlike COM add-ins, Office Add-ins don't involve code that runs on the user's device or in the Office client. For an Office Add-in, the host application, for example Excel, reads the add-in manifest and hooks up the add-in’s custom ribbon buttons and menu commands in the UI. When needed, it loads the add-in's JavaScript and HTML code, which executes in the context of a browser in a sandbox.

相较于使用 VBA、COM 或 VSTO 生成的加载项，Office 加载项提供以下优势：Office Add-ins provide the following advantages over add-ins built using VBA, COM, or VSTO:

跨平台支持。Office 加载项在 Office 网页版、Windows 版 Office、Mac 版 Office 和 iPad 版 Office中运行。Cross-platform support. Office Add-ins run in Office on the web, Windows, Mac, and iPad.
集中部署和分发：管理员可以在整个组织内集中部署 Office 加载项。Centralized deployment and distribution. Admins can deploy Office Add-ins centrally across an organization.
可通过 AppSource 轻松使用：可以将解决方案提交到 AppSource，供广大受众使用。Easy access via AppSource. You can make your solution available to a broad audience by submitting it to AppSource.
以标准 Web 技术为依据：可以使用所需的任何库来生成 Office 加载项。Based on standard web technology. You can use any library you like to build Office Add-ins.

Office 外接程序的组件Components of an Office Add-in

Office 外接程序包括两个基本组件：XML 清单文件和你自己的 Web 应用程序。此清单定义各种设置，包括将外接程序与 Office 客户端集成的方式。需要在 Web 服务器或 Web 托管服务上托管 Web 应用程序，例如 Microsoft Azure。An Office Add-in includes two basic components: an XML manifest file, and your own web application. The manifest defines various settings, including how your add-in integrates with Office clients. Your web application needs to be hosted on a web server, or web hosting service, such as Microsoft Azure.

清单Manifest

清单是一个 XML 文件，它指定外接程序的设置和功能，例如：The manifest is an XML file that specifies settings and capabilities of the add-in, such as:

外接程序的显示名称、说明、ID、版本和默认区域设置。The add-in's display name, description, ID, version, and default locale.
如何将外接程序与 Office 集成。How the add-in integrates with Office.
外接程序的权限级别和数据访问要求。The permission level and data access requirements for the add-in.

Web 应用Web app

最基本的 Office 加载项包括在 Office 应用中显示的静态 HTML 页面，但此页面并不与 Office 文档或其他任何 Internet 资源交互。不过，若要创建与 Office 文档交互的体验，或创建允许用户通过 Office 主机应用与在线资源交互的体验，可以使用托管提供程序支持的任何客户端和服务器端技术（如 ASP.NET、PHP 或 Node.js）。若要与 Office 客户端和文档交互，可以使用 Office.js JavaScript API。The most basic Office Add-in consists of a static HTML page that is displayed inside an Office application, but that doesn't interact with either the Office document or any other Internet resource. However, to create an experience that interacts with Office documents or allows the user to interact with online resources from an Office host application, you can use any technologies, both client and server side, that your hosting provider supports (such as ASP.NET, PHP, or Node.js). To interact with Office clients and documents, you use the Office.js JavaScript APIs.

图 2：Hello World Office 加载项的组件Figure 2. Components of a Hello World Office Add-in

扩展并与 Office 客户端交互Extending and interacting with Office clients

Office 外接程序可以在 Office 主机应用程序中执行下列操作：Office Add-ins can do the following within an Office host application:

扩展功能（任何 Office 应用程序）Extend functionality (any Office application)
创建新的对象（Excel 或 PowerPoint）Create new objects (Excel or PowerPoint)

扩展 Office 功能Extend Office functionality

Microsoft Excel Mac Add Ins Account

可以通过以下方式向 Office 应用程序添加新功能：You can add new functionality to Office applications via the following:

自定义功能区按钮和菜单命令（统称为“外接程序命令”）Custom ribbon buttons and menu commands (collectively called “add-in commands”)
可插入的任务窗格Insertable task panes

自定义 UI 和任务窗格在外接程序清单中进行指定。Custom UI and task panes are specified in the add-in manifest.

自定义按钮和菜单命令Custom buttons and menu commands

可以向 Office 网页版和 Windows 版 Office 中的功能区添加自定义功能区按钮和菜单项。这样一来，用户可以直接从 Office 应用程序访问加载项。命令按钮可以启动不同的操作，如显示包含自定义 HTML 的任务窗格或执行 JavaScript 函数。You can add custom ribbon buttons and menu items to the ribbon in Office on the web and Windows. This makes it easy for users to access your add-in directly from their Office application. Command buttons can launch different actions such as showing a task pane with custom HTML or executing a JavaScript function.

图 3. 功能区中的加载项命令Figure 3. Add-in commands in the ribbon

任务窗格Task panes

除了通过加载项命令以外，用户还可以使用任务窗格与解决方案进行交互。不支持加载项命令的客户端（Office 2013 和 iPad 版 Office）以任务窗格的形式运行加载项。用户通过“插入”**** 选项卡上的“我的加载项”**** 按钮，启动任务窗格加载项。You can use task panes in addition to add-in commands to enable users to interact with your solution. Clients that do not support add-in commands (Office 2013 and Office on iPad) run your add-in as a task pane. Users launch task pane add-ins via the My Add-ins button on the Insert tab.

图 4：任务窗格Figure 4. Task pane

扩展 Outlook 功能Extend Outlook functionality

Outlook 外接程序可扩展 Office 功能区，还可以在查看或撰写 Outlook 项目时在其旁边的上下文中显示。当用户查看接收的项目或回复或创建新项目时，它们可以与电子邮件、会议请求、会议响应、会议取消或约会一起使用。Outlook add-ins can extend the Office ribbon and also display contextually next to an Outlook item when you're viewing or composing it. They can work with an email message, meeting request, meeting response, meeting cancellation, or appointment when a user is viewing a received item or replying or creating a new item.

Outlook 加载项可以访问邮件项目中的上下文信息（如地址或跟踪 ID），然后使用此类数据来访问服务器和 Web 服务上的其他信息，以打造极具吸引力的用户体验。在大多数情况下，Outlook 加载项无需修改即可在 Outlook 主机应用程序上运行，以在桌面、Web 以及平板电脑和移动设备上提供无缝体验。Outlook add-ins can access contextual information from the item, such as an address or tracking ID, and then use that data to access additional information on the server and from web services to create compelling user experiences. In most cases, an Outlook add-in runs without modification in the Outlook host application to provide a seamless experience on the desktop, web, and tablet and mobile devices.

有关 Outlook 加载项的概述，请参阅 Outlook 加载项概述。For an overview of Outlook add-ins, see Outlook add-ins overview.

Microsoft Excel Add Ins

在 Office 文档中新建对象Create new objects in Office documents

可以在 Excel 和 PowerPoint 文档中嵌入基于 Web 的对象（称为“内容加载项”）。通过内容加载项，可以集成基于 Web 的丰富数据可视化、媒体（如 YouTube 视频播放器或图片库）和其他外部内容。You can embed web-based objects called content add-ins within Excel and PowerPoint documents. With content add-ins, you can integrate rich, web-based data visualizations, media (such as a YouTube video player or a picture gallery), and other external content.

图 5：内容加载项Figure 5. Content add-in

Office JavaScript APIOffice JavaScript APIs

Office JavaScript API 包含的对象和成员适用于生成加载项，并与 Office 内容和 Web 服务交互。Excel、Outlook、Word、PowerPoint、OneNote 和 Project 共用一个常见对象模型。对于 Excel 和 Word，还有更多主机专用对象模型。这些 API 提供对已知对象（如段落和工作簿）的访问权限，以便于能够更轻松地为特定主机创建加载项。The Office JavaScript APIs contain objects and members for building add-ins and interacting with Office content and web services. There is a common object model that is shared by Excel, Outlook, Word, PowerPoint, OneNote and Project. There are also more extensive host-specific object models for Excel and Word. These APIs provide access to well-known objects such as paragraphs and workbooks, which makes it easier to create an add-in for a specific host.

后续步骤Next steps

有关开发 Office 加载项的更多详细介绍，请参阅构建 Office 加载项。For a more detailed introduction to developing Office Add-ins, see Building Office Add-ins.

n3h.netlify.com