Ability to export tabular data to Excel Online
Almost every web developer has or will encounter exporting reports to excel at one point or another in their careers. There are many options for doing this, but they all require a server side SDK from a third party vendor (paid or free). Some of them use standards like Open XML others use proprietary and old code.
I think it would be awesome to have a very easy and relative way to pass data to Excel Online, parse it and display it. Then allow the user to play with the spreadsheet online, save it to their OneDrive or download it locally.
Of course for this feature to be widely used by the development community and it turn by their users, the solution shouldn't require the user to be logged in at first.
Here's a great example of what I mean: https://playground.jsreport.net/#/playground/YBjmBsPFa
Click Run.
Of course this solution is using some proprietary technology through the Office Store (I believe?)
This would put Office Online to the forefront of lots and lots of users who have already been using Google Docs for quite some time.
jstawski
shared this idea
1 comment
-
Sudhi
commented
Hello, great example.
We do have parts of this already supported. For instance you can use Excel REST API available through Microsoft Graph to create and update Excel documents.
We are working on expanding the feature to include OneDrive consumer support so any end-user can take advantage of it.
Regarding the embedding the Excel view (or providing an URL to the developer to embed in an iFrame) - we don't yet have a way to do this. However this is an area we are going to be working on.