Build in Excel using Microsoft Graph API

Excel is probably Microsoft’s most popular developer tool. With a built-in functional programming language that supports lambdas and variables, Excel has become a tool for people to build their businesses, using it to manage and explore large amounts of data. It is no exaggeration to say that most of the world economy depends on Excel for the spreadsheet-based predictive models run by major banks.

However, there is one major problem with Excel applications. It’s hard to use and certainly hard to incorporate into modern applications. Complex simulations built over months may be ideal for line-of-business applications, but they are standalone applications and are not designed for use as a service that can be used in other code. Instead of automating forecasting and analysis, spreadsheets continue to be part of the manual workflow.

Excel extension with Microsoft Graph

Microsoft has moved to a web-based approach to working with Office applications. This opens up new opportunities for using Excel. Use JavaScript API Connect your custom Excel add-in to your line-of-business system Microsoft Graph endpoint for invoking Excel functions from approved applications.. The last option is the most interesting because it provides the tools you need to open Excel spreadsheets stored as headless applications in OneDrive for Business.

Working with Excel using the Graph API is relatively easy. This is a set of REST APIs that have a structure common to all calls. This allows you to quickly create URLs to access all the OneDrive locations you need to work with spreadsheets and books. It’s important to remember that your personal OneDrive account isn’t available. You need a SharePoint-based business account. This is controlled by Azure Active Directory.

If you want to get started right away, you can get 90 days free (renewable as many times as you need). Developer tenant.. This will give you all the tools you need to get started building your Microsoft Graph application.

Make Excel work with REST

First, use the Azure Active Directory API to grant the appropriate permissions to your application.These can Generate the correct access token This should be passed as part of a REST call to Microsoft Graph. Depending on how your application uses Excel, your application may need read-only or read-and-write access. Read-only access is ideal for applications that extract data from workbooks updated by task workers. Read and write access, on the other hand, is suitable for workbooks that apply functions to incoming data and work with external data sources.

Copyright © 2021 IDG Communications, Inc. Build in Excel using Microsoft Graph API

Back to top button