Learn What IT Pros Need to Know About Windows 11 - August 26th at 1 PM ET! Learn What IT Pros Need to Know About Windows 11 - August 26th at 1 PM ET!
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

Read the Best Personal and Business Tech without Ads

Staying updated on what is happening in the technology sector is important to your career and your personal life but ads can make reading news, distracting. With Thurrott Premium, you can enjoy the best coverage in tech without the annoying ads.

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.

Register for Advanced Microsoft 365 Day!

GET-IT: Advanced Microsoft 365 1-Day Virtual Conference - Live August 24th!

Join us on Tuesday, August 24th and hear from Microsoft MVPs and industry experts about how to take advantage of Microsoft 365 at a technical level and dive deep into the features and functionality that will make your environment more secure and compliant.


Sponsored By