Microsoft’s Excel API, which lets developers access data stored in spreadsheets, hits general availability
By Frederic Lardinois as written on techcrunch.com
After a relatively short beta, Microsoft today announced that the Excel API — a way for developers to programmatically use Excel for Office 365 for doing calculations, building dashboards and more — is now generally available.
Microsoft first announced the API last November and then detailed its plans for turning Office 365 into more of a platform for developers at it Build conference in March. Like all of Microsoft’s Office 365 APIs, the new Excel one will be available through the Microsoft Graph, the company’s unified API endpoint for all of its cloud services.
Implicitly, the Excel API acknowledges that most businesses use (and abuse) Excel to store lots of data. Using the service, developers will be able to perform calculations based on this data — and data from their apps outside of Office 365. The can also call on data and calculations from Excel sheets for building reports and dashboards.
Microsoft has partnered with two third-party services to make accessing this API easier. Zapier users, for example, can now build integrations with Excel for Office 365, and Sage, which offers business management service for small and medium businesses, is integrating it with its accounting solution.