Microsoft Graph Excel REST API ASP.NET to-do list sample
This sample shows how to read and write into an Excel document stored in your OneDrive for Business account by using the Excel REST APIs.
This sample requires the following:
Register the application
Sign into the Application Registration Portal using either your personal or work or school account.
Choose Add an app.
Enter a name for the app, and choose Create application.
The registration page displays, listing the properties of your app.
Copy the Application Id. This is the unique identifier for your app.
Under Application Secrets, choose Generate New Password. Copy the password from the New password generated dialog.
You'll use the application ID and password (secret) to configure the sample app in the next section.
Under Platforms, choose Add Platform.
Make sure the Allow Implicit Flow check box is selected, and enter http://localhost:21942/ as the Redirect URI.
The Allow Implicit Flow option enables the hybrid flow. During authentication, this enables the app to receive both sign-in info (the id_token) and artifacts (in this case, an authorization code) that the app can use to obtain an access token.
Configure the app
- Open Microsoft-Graph-ExcelRest-ToDo.sln file.
- In Solution Explorer, open the Web.config file.
- Replace ENTER_YOUR_CLIENT_ID with the client ID of your registered Azure application.
- Replace ENTER_YOUR_SECRET with the key of your registered Azure application.
Run the app
- Press F5 to build and debug. Run the solution and sign in with your organizational account. The application launches on your local host and shows the starter page.
Note: Copy and paste the start page URL address http://localhost:21942/home/index to a different browser if you get the following error during sign in: AADSTS70001: Application with identifier ad533dcf-ccad-469a-abed-acd1c8cc0d7d was not found in the directory.
- Choose the
Click here to sign inbutton in the middle of the page or the
Sign inlink at the top right of the page and authenticate with your Office 365 account.
- Select the
ToDoListlink from the top menu bar.
- The application checks to see if a file named
ToDoList.xlsxexists in the root OneDrive folder of your O365 account. If it doesn't find this file, it uploads a blank
ToDoList.xlsxworkbook and adds all of the necessary tables, columns, and rows, along with a chart. After finding or uploading and configuring the workbook, the application then displays the task list page. If the workbook contains no tasks, you'll see an empty list.
- If you're running the application for the first time, you can verify that the application uploaded and configured the
ToDoList.xlsxfile by navigating to https://yourtenant.sharepoint.com, clicking on the App Launcher "Waffle" at the top left of the page, and then choosing the OneDrive application. You'll see a file named ToDoList.xlsx in the root directory, and when you click on the file, you'll see worksheets named ToDoList and Summary. The ToDoList worksheet contains a table that lists each "to-do" item, and the Summary worksheet contains a summary table and a chart.
- Select the `Add New' link to add a new task. Fill in the form with the task details.
- After you add a task, the app shows the updated task listing. If the newly added task isn't updated, choose the
Refreshlink after a few moments.
- Choose the `Charts' link to see the breakdown of tasks in a pie chart that was created and downloaded by using the Excel REST API.
If you'd like to contribute to this sample, see CONTRIBUTING.MD.
Questions and comments
We'd love to get your feedback about the Microsoft Graph Excel REST API ASP.NET MVC sample. You can send your questions and suggestions to us in the Issues section of this repository.
Questions about Office 365 development in general should be posted to Stack Overflow. Make sure that your questions or comments are tagged with [MicrosoftGraph].
Copyright (c) 2018 Microsoft. All rights reserved.