4 ms·
I looked into the a while ago. There are some other options but the only ones that appear to be fairly robust are manipulation from either Microsoft Flow or Po
by tyingq 7y ago
I looked into the a while ago. There are some other options but the only ones that appear to be fairly robust are manipulation from either Microsoft Flow or Powerapps. Both of which are sort of "citizen development" visual type environments.
There is a second choice that works more like the Google sheets API...the Microsoft Graph API: https://docs.microsoft.com/en-us/graph/api/resources/excel https://docs.microsoft.com/en-us/graph/api/resources/excel
When I last tried it, it was somewhat limited in functionality.
- djsweet 7y agoHeads up on the Microsoft Graph API: it only works for certain styles of Microsoft Office customer. In particular, you can only authenticate against it with Azure AD, which completely chokes out the home market.
- nu5500 7y agoThat is not true. There are certain APIs only applicable to commercial users, but the same Graph API calls (for example against OneDrive or Excel) can be used across both.
- tyingq 7y agoIs that new? The post I linked to, from 9/2019, says "Support for workbooks stored in OneDrive Consumer platform is still not available. At this time, only the files stored in business platform is supported by Excel REST APIs."