17 07 2013
REST is trendy and quickly becoming the go-to technology for modern web development, and this little gem has been hiding in the background.
To use it, simply create a workbook with some charts or tables (and name them appropriately, otherwise use the defaults of Table1 or Chart1, etc), and upload it to a Trusted Location somewhere in your site.
Then, access a URL of a similar format:
All things going well, you will get a PNG of the chart!
And this works great for other resources, such as tables and ranges of worksheets. The supported data formats are HTML, ATOM and PNG (for images), as well as the workbook itself (coming down as the original file, essentially). All you need to do is build the URL properly and specify the format.
This opens up a world of possibilities for you to be able to access data and charts within workbooks from other applications or pages in your enterprise environment.
If you want to have a mess with these APIs and see what’s possible, and you don’t yet have an environment available to try them on, have a look at Excel Mashup which has a decent array of examples and resources to show you what’s possible.