Here is a fun and unexpected 4th of July surprise. Last year on this very same day I was playing with the Hortonworks Sandbox. This year while out and about, I noticed Chris Webb (@technitrain) tweeted a cool little blog about embedding Excel into web sites via OneDrive. In true data addict fashion, I rushed home to check it out after our neighborhood get together. Sure enough there is a new Share feature in Excel Online for embedding Excel into a public web site or blog. You can access this feature on a OneDrive stored Excel file. In OneDrive, click an Excel file to view it online in the web browser. Then in the Excel Online menu under File > Share you can see the new Embed option. The Embed option item allows you to specify an entire Excel workbook, specific charts or tables. It also has options for interactivity. I noticed that Power View does not work but I would bet that it might be coming super soon, possibly only for Power BI accounts…not sure, since we have seen Microsoft’s uber-talented Shish showcasing Power View from time to time on his blog this year. I did ask about it and was informed that this feature is indeed on the way but no other details were released.
I also noticed that there are options on the bottom of the Excel Web App embedded container that allow you to Download or View the full-size Excel workbook from a web browser…and it seems to work with a variety of web browsers including the default ones on my iPad and iPhone.
Here is my old Excel Services mobile-friendly BI demo file that you can actually interactively explore, click slicers, sort and so on. I still have to figure out how to control quite a few things like zoom level and sizing. I don’t know if Excel Mashup Interactive View for web sites will continue on but they do seem like totally different implementations. In the meantime, enjoy!