Name: PowerPoint-Add-in-Microsoft-Graph-ASPNET-InsertChart
Owner: Office Developer
Description: An add-in connecting to OneDrive, finds workbooks, returns charts and inserts charts onto slides using Office.js
Created: 2016-03-17 16:42:20.0
Updated: 2017-12-10 20:28:34.0
Pushed: 2018-01-16 17:44:05.0
Size: 1115
Language: JavaScript
GitHub Committers
User | Most Recent Commit | # Commits |
---|
Other Committers
User | Most Recent Commit | # Commits |
---|
Learn how to build a Microsoft Office Add-in that connects to Microsoft Graph, finds all workbooks stored in OneDrive for Business, fetches all charts in the workbooks using the Excel REST APIs, and inserts an image of a chart into a PowerPoint slide using Office.js.
Integrating data from online service providers increases the value and adoption of your add-ins. This code sample shows you how to connect your add-in to Microsoft Graph. Use this code sample to:
To run this code sample, the following are required.
Visual Studio 2015.
An Office 365 account which you can get by joining the Office 365 Developer Program that includes a free 1 year subscription to Office 365.
Excel workbooks (with charts) stored on OneDrive for Business in your Office 365 subscription.
PowerPoint for Windows Desktop, version 16.0.6769.2001 or higher.
A Microsoft Azure Tenant. This add-in requires Azure Active Directiory (AD). Azure AD provides identity services that applications use for authentication and authorization. A trial subscription can be acquired here: Microsoft Azure.
In Visual Studio, choose the PowerPoint-Add-in-Microsoft-Graph-ASPNET-InsertChartWeb project. In Properties, ensure SSL Enabled is True. Verify that the SSL URL uses the same domain name and port number as those listed in step 3 below.
Ensure your Azure subscription is bound to your Office 365 tenant. For more information, see the Active Directory team's blog post, Creating and Managing Multiple Windows Azure Active Directories. The section Adding a new directory will explain how to do this. You can also see Set up your Office 365 development environment and the section Associate your Office 365 account with Azure AD to create and manage apps for more information.
Register your application using the Azure Management Portal. To learn how to register your application, see Register your browser-based web app with the Azure Management Portal. Use the following settings:
SIGN-ON URL: https://localhost:44301/AzureADAuth/Authorize
APP ID URI: https://localhost:44301
REPLY URL: https://localhost:44301/AzureADAuth/Authorize
Note: After you register your application, copy the client id and client secret that is shown in the Azure Management Portal.
Grant permissions to your application.
In web.config, set AAD:ClientID to your client id, and set AAD:ClientSecret to your client secret.
We'd love to get your feedback about the Insert Excel charts using Microsoft Graph in a PowerPoint Add-in sample. You can send your feedback to us in the Issues section of this repository. Questions about Office 365 development in general should be posted to Stack Overflow. Ensure your questions are tagged with [office-js], [MicrosoftGraph] and [API].
Copyright (c) 2016 Microsoft Corporation. All rights reserved.
This project has adopted the Microsoft Open Source Code of Conduct. For more information, see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.