Microsoft today announced the general availability of the Microsoft Excel REST API for Office 365 allowing developers to use Excel to power custom apps. The new Excel REST API is exposed through the Microsoft Graph to access to intelligence and insights from the Microsoft cloud.
How developers can use the new Excel REST API:
Excel as a calculation service: Users love the ease with which they can perform deep and complex calculations within Excel. Developers can now access Excel’s powerful calculation engine with instant results.
Excel as a reporting service: Developers can have full access to all of Excel’s reporting features—making Excel an online reporting service within Office 365. Imagine any of the reporting scenarios users rely on today pulled into a custom app to create professional charts or analyze large sets of data intelligently, seamlessly blending Excel into those customized experiences.
Excel as a data service: Excel is also a great tool to store and track data. If your information is stored in a workbook, that data is available to any app integrating with Office 365, making its contents available to read from custom solutions and enabling them to use Excel as the data storage.
For documentation and code samples, visit this link.