Microsoft Excel API Now Available for Office 365
Learn how developers can power custom apps with the new Microsoft Excel API powered by Office 365
Microsoft recently announced the general availability of the Excel REST API for Office 365, which will allow developers to power custom apps with Excel. As you likely are aware, this vital spreadsheet software is used in a variety of ways, including for simple task tracking and data management, as well as professional reporting and extremely complex calculations.
What is the Excel REST API?
The Excel REST API is part of Microsoft’s mission to make Office a more open platform for developers. The Office developer framework uses the latest web development standards to allow developers to build apps that seamlessly integrate with the platform on the web, and mobile and desktop platforms.
How can developers use the new Excel REST API?
There are a number of ways that developers should be able to benefit from the new Excel REST API to power their custom applications, including:
Excel as a reporting tool
Excel is used all over the world to create everything from simple data tables to professional charts and dashboards. With the Excel REST API, developers now have access to all of the program’s reporting features within their custom apps. This allows them to create sleek and professional charts, or analyze massive datasets seamlessly from within a custom app.
Excel as a calculation tool
Users have always loved Excel’s ability to perform complex calculations. Now developers can leverage this same power to perform calculations within a custom application. Excel does the heavy lifting, which frees up valuable resources. With the Excel REST API, developers will have access to more than 300 worksheet functions, which should make most complex business calculations a breeze.
Excel as a data storage tool
Excel offers users a great tool for data tracking and storage. If you store data in a workbook, it is available to any app that integrates with Office 365 through the Excel REST API. A number of cloud solution companies like Zapier and Sage are already working on ways to take advantage of this new functionality.
Interested in learning more about building custom apps with Excel?
Microsoft has put together an area on their website dedicated to documentation and code samples to get you started building custom apps that interface with Excel. With just a few lines of code, you can have a basic integration with the spreadsheet software, as outlined in this basic Excel to-do list sample provided by Microsoft.
At MessageOps, we’re excited to see how our customers can leverage the power of the new Excel REST API. If you’re looking to learn more about Office 365 as a whole, or how it can help streamline your business, don’t hesitate to reach out to our team of Office 365 migration experts at 877-788-1617 or through our online contact form.