Office 365

Microsoft’s New Excel API Is A Leap Forward For The Spreadsheet Application

Office 365 Hero

Microsoft is announcing today the general availability of its Excel API and on the surface, this seems like another simple feature for Office 365 but under-the-hood, this is a powerful update. Starting today, developers can use the Excel REST API to incorporate complex calculations easily into applications utilizing this new tool.

In the corporate world, Excel is a fundamental app that is used in everything from financial reporting and forecasting sales for the upcoming quarter to keeping track of inventory. Quite frankly, many smaller companies are using Excel to operate their entire business and baked inside of these spreadsheets are complex computations that often need to be utilized for other applications to help make business decisions.

The Excel API is a tool that developers can now use to access Excel data inside of spreadsheets which means that complex models no longer have to be rebuilt inside of applications. This is a significant improvement to the process flow of utilizing data inside of the Microsoft Graph as it reduces the likelihood of an error being coded into a model and reduces the time to build an application as you no longer need to build the model in the first place.

Sponsored Content

Maximize Value from Microsoft Defender

In this ebook, you’ll learn why Red Canary’s platform and expertise bring you the highest possible value from your Microsoft Defender for Endpoint investment, deployment, or migration.

The extensibility that this API brings to Excel will further solidify its position in the corporate world as an indispensable tool for a variety of scenarios. Considering that the API is just now making its way into a production-ready state, it will be interesting to see how quickly developers make use of this new tool to extend the reach of the spreadsheet application and how this feature will change the rate at which new applications are built.

If you are looking to build an application using the new API, you can find code samples and documentation here.

Related Topics:


Don't have a login but want to join the conversation? Sign up for a Petri Account

Comments (0)

Leave a Reply

Brad Sams has more than a decade of writing and publishing experience under his belt including helping to establish new and seasoned publications From breaking news about upcoming Microsoft products to telling the story of how a billion dollar brand was birthed in his book, Beneath a Surface, Brad is a well-rounded journalist who has established himself as a trusted name in the industry.
External Sharing and Guest User Access in Microsoft 365 and Teams

This eBook will dive into policy considerations you need to make when creating and managing guest user access to your Teams network, as well as the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

You will learn:

  • Who should be allowed to be invited as a guest?
  • What type of guests should be able to access files in SharePoint and OneDrive?
  • How should guests be offboarded?
  • How should you determine who has access to sensitive information in your environment?

Sponsored by: