OfficeDev/Office-Add-in-samples
OfficeDev/Office-Add-in-samples được TopGit xếp vào nhóm dự án mã nguồn mở, với 1.0k sao trên GitHub, viết chủ yếu bằng JavaScript. Code samples for Office Add-in development on the Microsoft 365 platform.
Tóm tắt dựng từ metadata GitHub của chính dự án — chưa có bài review TopGit. Trang sẽ tự động cập nhật khi bài review đầy đủ được xuất bản.
TopGit viết bài đầy đủ cho repo có nhiều sao nhất và được yêu cầu nhiều nhất. Trang này là snapshot trong thời gian chờ — xem README gốc ở tab READ ME.
Snapshot
Cộng tác viên hàng đầu
Xem cộng tác viên hàng đầu
Office Add-ins code samples
Office Add-ins code samples are provided in this repo to help you learn, study, and build great Office Add-ins!
Getting started
The following samples show how to build the simplest Office Add-in with only a manifest, HTML web page, and a logo. They will help you understand the fundamental parts of an Office Add-in. For additional getting started information, see our quick starts and tutorials.
Task pane add-ins
- Excel "Hello world" add-in
- Outlook "Hello world" add-in
- PowerPoint "Hello world" add-in
- Word "Hello world" add-in
Content add-ins
- Excel "Hello world" content add-in
- PowerPoint "Hello world" content add-in
Completed tutorials
The following samples are the completed versions of various tutorials for Office Add-ins.
| Name | Description |
|---|---|
| Excel Tutorial - Completed | This sample is the completed version of the Tutorial: Create an Excel task pane add-in that shows how to create an Excel add-in with a task pane and command ribbon buttons. The add-in shows how to create and sort a table, make a chart, freeze a row, protect a worksheet, and display a dialog box. |
| Outlook Tutorial - Completed | This sample is the completed version of the Tutorial: Build a message compose Outlook add-in that shows how to build an Outlook add-in that can be used in message compose mode to insert content into the body of a message. The add-in shows how to collect information from the user, fetch data from an external service, implement a function command, implement a task pane, and display a dialog box. |
| PowerPoint Tutorial (Visual Studio) - Completed | This sample is the completed version of the Tutorial: Create a PowerPoint task pane add-in that shows how to create a PowerPoint add-in with a task pane. The add-in shows how to add the Bing photo of the day to a slide, add text to a slide, get slide metadata, and navigate between slides. |
| PowerPoint Tutorial (yo office) - Completed | This sample is the completed version of the Tutorial: Create a PowerPoint task pane add-in that shows how to create a PowerPoint add-in with a task pane. The add-in shows how to add an image to a slide, add text to a slide, get slide metadata, and navigate between slides. |
| Word Tutorial - Completed | This sample is the completed version of the Tutorial: Create a Word task pane add-in that shows how to create a Word add-in with a task pane. The add-in shows how to insert and replace text ranges, paragraphs, images, HTML, tables, and content controls. The add-in also shows how to format text and how to manage content in content controls. |
| Office Add-in First-run Experience Tutorial - Completed | This sample is the result of completing the Build an Office Add-in with a basic first-run experience that shows the basics of implementing a first-run experience (FRE). Excel is used in this sample but the pattern can be applied to other Office applications where Office Web Add-ins are supported. |
Blazor WebAssembly
| Name | Description |
|---|---|
| Create a Blazor WebAssembly Excel add-in | Uses .NET Blazor technologies to build an Excel add-in. |
| Create a Blazor WebAssembly Word add-in | Uses .NET Blazor technologies to build a Word add-in. |
| Create a Blazor WebAssembly Outlook add-in | Uses .NET Blazor technologies to build an Outlook add-in. |
Authentication, authorization, and single sign-on (SSO)
The following samples show how to access and work with a user's Microsoft Graph data using the Microsoft identity platform.
| Name | Applies to | Description |
|---|---|---|
| Office Add-in with SSO using nested app authentication | Excel PowerPoint Word | Shows how to use MSAL.js nested app authentication (NAA) in an Office Add-in to access Microsoft Graph APIs for the signed-in user. The sample displays the signed-in user's name and email. It also inserts the names of files from the user's Microsoft OneDrive account into the document. |
| Office Add-in with SSO using nested app authentication | Outlook | Shows how to use MSAL.js nested app authentication (NAA) in an Outlook Add-in to access Microsoft Graph APIs for the signed-in user. The sample displays the signed-in user's name and email. It also inserts the names of files from the user's Microsoft OneDrive account into a new message body. |
| Use SSO with event-based activation in an Outlook add-in | Outlook | Shows how to use SSO to access a user's Microsoft Graph data from an event handled by an Outlook add-in. |
| SSO Sample Outlook Add-in | Outlook | Uses Office's SSO feature to give the add-in access to Microsoft Graph data. |
| Get OneDrive data using Microsoft Graph and MSAL.js in an Office Add-in | Excel | Builds an Office Add-in as a single-page application (SPA) with no backend. The sample uses Microsoft Graph to access workbooks stored in OneDrive for Business. Information from the workbooks is then inserted into an Office document. |
| Get OneDrive data using Microsoft Graph and MSAL.NET in an Office Add-in | Excel PowerPoint Word | Builds an Office Add-in that uses Microsoft Graph to access workbooks stored in OneDrive for Business. Information from the workbooks is then inserted into an Office document. |
| Get Excel workbooks using Microsoft Graph and MSAL in an Outlook Add-in | Outlook | Builds an Outlook add-in that connects to Microsoft Graph to access workbooks stored in OneDrive for Business. Information from the workbooks is then used to compose a new email message. |
| SSO Office Add-in with ASP.NET | Excel PowerPoint Word | Uses the getAccessToken API in Office.js to give the add-in access to Microsoft Graph data. This sample is built on ASP.NET. |
| SSO Office Add-in with Node.js | Excel PowerPoint Word | Uses the getAccessToken API in Office.js to give the add-in access to Microsoft Graph data. This sample is built on Node.js. |
Office
| Name | Description |
|---|---|
| Save custom settings in your Office Add-in | Shows how to save custom settings inside an Office Add-in. The add-in stores data as key/value pairs, using the JavaScript API for Office property bag, browser cookies, web storage (localStorage and sessionStorage), or by storing the data in a hidden div in the document. |
| Use keyboard shortcuts for Office Add-in actions | Shows how to create custom keyboard shortcuts to invoke certain actions for your Office Add-in. |
| Define KeyTips for the ribbon controls of an Office Add-in | Shows how to define KeyTips for ribbon controls of an Office Add-in. |
Outlook
| Name | Description |
|---|---|
| Encrypt attachments, process meeting request attendees, and react to appointment date/time changes using Outlook event-based activation | Shows how to use event-based activation to encrypt attachments when added by the user. Also shows event handling for recipients changed in a meeting request, and changes to the start or end date or time in a meeting request. |
| Identify and tag external recipients using Outlook event-based activation | Uses event-based activation to run an Outlook add-in when the user changes recipients while composing a message. The add-in also uses the appendOnSendAsync API to add a disclaimer. |
| Set your signature using Outlook event-based activation | Uses event-based activation to run an Outlook add-in when the user creates a new message or appointment. |
| Verify the color categories of a message or appointment before it's sent using Smart Alerts | Uses Outlook Smart Alerts to verify that required color categories are applied to a new message or appointment before it's sent. |
| Verify the sensitivity label of a message | Uses the sensitivity label API in an event-based add-in to verify and apply the Highly Confidential sensitivity label to applicable outgoing messages. |
| Report spam or phishing emails in Outlook | Builds an integrated spam-reporting add-in that's displayed in a prominent spot on the Outlook ribbon. |
| Encrypt and decrypt messages in Outlook | Uses Outlook Smart Alerts and the OnMessageDecrypt event to encrypt and decrypt messages. |
| Invoke an Outlook add-in from an actionable message | Uses an Adaptive Card in an actionable message to activate an add-in and display initialization context data. |
Excel
| Name | Description |
|---|---|
| Create an Excel workbook from a web site with an auto-open task pane | Shows how to create an Excel workbook from web site data using Node.js, and configure it so that a custom Office Add-in task pane automatically opens when the document is opened. |
| Data types explorer | Builds an Excel add-in that allows you to create and explore data types in your workbooks. Data types enable add-in developers to organize complex data structures as objects, such as formatted number values, web images, and entity values. |
| Open in Teams | Creates a new Excel spreadsheet in Microsoft Teams containing data you define. |
| Insert an external Excel file and populate it with JSON data | Insert an existing template from an external Excel file into the currently open Excel file. Then retrieve data from a JSON web service and populate the template for the customer. |
| Create custom contextual tabs on the ribbon | This sample shows how to create a custom contextual tab on the ribbon in the Office UI. The sample creates a table, and when the user moves the focus inside the table, the custom tab is displayed. When the user moves outside the table, the custom tab is hidden. |
| Custom function sample using web worker | Shows how to use web workers in custom functions to prevent blocking the UI of your Office Add-in. |
| Use storage techniques to access data from an Office Add-in when offline | Demonstrates how you can implement localStorage to enable limited functionality for your Office Add-in when a user experiences lost connection. |
| Custom function batching pattern | Batch multiple calls into a single call to reduce the number of network calls to a remote service. |
| Excel content add-in | Embed a content add-in in the Excel grid. |
| Excel content add-in with data visualization | Create an Excel content add-in that includes data visualization. |
| Synchronous custom function sample (preview) | A synchronous custom function that reads a cell value in tandem with Excel's calculation process using @supportSync. This feature is in public preview. |
| Skill for Copilot in Excel (preview) | Create a custom skill for Copilot in Excel that uses the Excel-specific APIs in the Office JavaScript library to find and chart table rows which embody an accelerating growth trend. This feature is in public preview. |
Word
| Name | Description |
|---|---|
| Automatically add labels with an add-in when a Word document opens | Shows how to configure a Word add-in to activate when a document opens. |
| Get, edit, and set OOXML content in a Word document with a Word add-in | Shows how to get, edit, and set OOXML content in a Word document. |
| Import a Word document template with a Word add-in | Shows how to import templates in a Word document. |
| Load and write Open XML in your Word add-in | Shows how to add a variety of rich content types to a Word document using the setSelectedDataAsync method with ooxml coercion type. |
| Manage citations with your Word add-in | Shows how to manage citations in a Word document. |
Shared JavaScript runtime
Check out these samples if you want to take advantage of the shared runtime for your Office Add-in.
| Name | Description |
|---|---|
| Share global data with a shared runtime | Shows how to set up a basic project that uses the shared runtime to run code for ribbon buttons, task pane, and custom functions in a single browser runtime. |
| Manage ribbon and task pane UI, and run code on doc open | Shows how to create contextual ribbon buttons that are enabled based on the state of your add-in. |
Additional samples
| Name | Description |
|---|---|
| Use a shared library to migrate your Visual Studio Tools for Office add-in to an Office web add-in | Provides a strategy for code reuse when migrating from VSTO Add-ins to Office Add-ins. |
| Integrate an Azure function with your Excel custom function | Learn how to integrate Azure functions with custom functions to move to the cloud or integrate additional services. |
| Dynamic DPI code samples | A collection of samples for handling DPI changes in COM, VSTO, and Office Add-ins. |
| Rubric grader task pane add-in for OneNote on the web | Explore the basics of OneNote add-ins with a sample tool for teachers. |
Learn more
To learn more about Office Add-ins, see the Office Add-ins documentation.
Questions and feedback
- Did you experience any problems with a sample? Create an issue and we'll help you out.
- We'd love to get your feedback about the samples. Go to our Office samples survey to give feedback and suggest improvements.
- For general questions about developing Office Add-ins, go to Microsoft Q&A using the office-js-dev tag.
Join the Microsoft 365 Developer Program
Join the Microsoft 365 Developer Program to get resources and information to help you build solutions for the Microsoft 365 platform, including recommendations tailored to your areas of interest.
You might also qualify for a free developer subscription that's renewable for 90 days and comes configured with sample data; for details, see the FAQ.
Community
The Office Add-ins code samples are a community-driven effort that helps developers extend, build, and provision customizations for the Office platform. The source is maintained on this GitHub repo where anyone can participate. You can provide contributions to the samples, reusable components, and documentation. Office Add-ins code samples is owned and coordinated by Office engineering teams, but the work is done by the community for the community.
Please read the Contribute page to learn how to be an active part of this community.
Code of conduct
This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.
Repo liên quan
Master programming by recreating your favorite technologies from scratch.
A curated meta-list of curated lists organized by technology domain. The repository acts as a directory pointing to hundreds of specialized awesome lists covering programming languages, platforms, frameworks, and tooling. All content is community-contributed under the CC0 public domain dedication.
Public APIs is a community-curated GitHub repository listing free, publicly accessible APIs across a wide range of categories, with auth type, HTTPS, and CORS noted for each entry. It's a browsable reference, not a library to install.
freeCodeCamp is a free, self-paced curriculum for learning to code, published as open source at freeCodeCamp/freeCodeCamp. It's a 501(c)(3) nonprofit funded by donor support, structured around six certifications in its Full-Stack Developer Curriculum, each gated by required projects instead of open-book quizzes. The repository also carries beta language certifications for developers, interview-prep resources, and the code that runs the live freecodecamp.org platform.
Trả lời nhanh
OfficeDev/Office-Add-in-samples có bao nhiêu sao?
OfficeDev/Office-Add-in-samples có 1.0k sao GitHub — tải lại trang để xem số mới nhất, hoặc xem trực tiếp github.com/OfficeDev/Office-Add-in-samples. TopGit phản chiếu số sao của GitHub nhưng không cam kết đến từng phút.
OfficeDev/Office-Add-in-samples có những chủ đề gì?
GitHub topics của OfficeDev/Office-Add-in-samples: "pnp", "practices", "samples". TopGit xếp repo vào nhóm mã nguồn mở.
OfficeDev/Office-Add-in-samples còn đang phát triển không?
Commit gần nhất trên OfficeDev/Office-Add-in-samples là 7 ngày trước (theo timestamp GitHub). Repo có 950 fork — một chỉ báo về mức độ quan tâm của cộng đồng.
OfficeDev/Office-Add-in-samples là gì?
OfficeDev/Office-Add-in-samples (OfficeDev/Office-Add-in-samples) là dự án JavaScript trên GitHub. Theo mô tả gốc: Code samples for Office Add-in development on the Microsoft 365 platform.
OfficeDev/Office-Add-in-samples viết bằng ngôn ngữ gì?
OfficeDev/Office-Add-in-samples chủ yếu viết bằng JavaScript. Trường "language" của GitHub dựa trên phần lớn byte ở nhánh mặc định.
Đọc đầy đủ README ở tab phía trên.
Muốn nghe thêm một ý kiến về Office-Add-in-samples?
Hỏi một AI đọc được trang này — một cú bấm là có ngay nhận định về Office-Add-in-samples.