The Channel logo

News

By | Gavin Clarke 5th August 2016 08:57

Quip away, but Microsoft Excel 365's REST APIs win the day

Even Salesforce knows the score here

Salesforce has splashed out $582m on what some hail as its alternative to MS Word. Without spending anything, Microsoft has shown the true meaning of power.

For years, it has been macro makers who have done the daily work of making Office more and more useful to end users, embedding it more into daily working life.

Now, as Office has shifted to the cloud with Office 365, it’s time for web devs to follow suit. To that end, Microsoft has released an Office 365 API for developers to add Excel-based calculations to web apps.

The Excel REST API for Office 365 is the plumbing to Microsoft’s Graph, which connects relationships between entities – so Graph as in graph database.

The software giant has targeted not desk jockeys or tablet warriors in its move; rather, devs are now set to be using a code drop that promises to consolidate Microsoft’s Office brand.

According to a Microsoft blog post here, devs will be able to tap into more than 300 Excel worksheet functions, giving “full access to the breadth of formula supported by Excel.”

The idea is you don’t need to build complex business models and use an API call to Graph.

[Insert name here] takes on Office

Quip is a mobile-first productivity app akin to Office 365 and Google’s Docs. Many will be tempted to see Quip as the personal productivity brick in the white-collar puzzle that encompasses CRM – and thus Salesforce's attempt to take on Office and Microsoft.

But Quip will remain little more than a nice afterthought – something for those who dislike Microsoft and Google so much that they prefer gluing together their own business apps using a suite of Salesforce, Box and anybody else.

These people are small in number.

The reason is that Microsoft has been so busy stuffing Office 365 into corporate accounts under its enterprise licenses that this market is small. Moreover, many of those accounts were already die-hard Windows – and, moreover, Office – shops.

Microsoft defined productivity on the desktop with Office apps Excel and Word in the 1980s and 1990s to such an extent that Google was forced to copy the look and functionality of Office with its Google Docs product.

When Microsoft changed things up with the new ribbon interface in Office 2007, customers got a nasty shock and people clung to the ageing versions of their favourite suite.

Salesforce has recognised the power of Office 365 and has an extensive integration deal between its CRM cloud and Microsoft’s suite.

Making the mechanics of Excel 365 available as a REST service does nothing but make Excel even easier to integrate into a new generation of apps that aren’t on the desktop, but are on something far more important: the web and the device.

Moreover, that Excel 365 is double bubble for Microsoft as it will feed ever more data into Redmond’s Graph relationship engine. ®

comment icon Read 25 comments on this article or post a comment alert Send corrections

Opinion

Baby looks taken aback/shocked/affronted. Photo by Shutterstock

Kat Hall

Plans for 2 million FTTP connections in next four years 'not enough'
Microsoft CEO Satya Nadella
Stranded_ships

Chris Mellor

Thousands of layoffs announced as spinning rust enters its death spiral

Features

Locker room jocks photo via Shutterstock
Best locker-room strategy: Avoid emulating AWS directly
STRASBOURG, JUNE 29, 2016: The seat of the European Parliament. by Marco Aprile for shutterstock. EDITORIAL USE ONLY
Plan b, image via Shutterstock
EU workers, new markets: post-Brexit pressure on May & Co
Tough question, pic via Shutterstock