At the last MVP summit we were shown some great examples of the new Excel WebApp. After seeing that I immediately went and updated a few pages on my website to make them as interactive as possible.
Since this is a help forum, I think this could be a very valuable tool to help demonstrate things to our question askers as well.
One challenge with the WebApp though, is that runs in an iFrame. Due to security, I didn't really want to allow just any iFrame on my site, so I've created some BB Code tags specific to the Microsoft webapp. These tags will allow you to embed a file right into the forum web pages.
Here's how they work...
Assume you have uploaded your file to your Windows Live SkyDrive account.
- Make sure the file is in a shared folder.
- Navigate in SkyDrive to the file, but don't open it.
- Hold your mouse over the file name, and a bar should pop up.
- Navigate to More --> Share --> Embed
For this example, we'll assume the code is as follows:
- Copy the code from the embed window.
What we're going to do is copy everything from between the ?su- and the &Allow. In other words:
<iframe src="http://r.office.microsoft.com/r/rlidExcelEmbed?su=-8493146133887032856&Fi=SD8A224897002E61E8!258&AllowInteractivity=False" width="402" height="346" frameborder="0" scrolling="no"></iframe>
Now we'll insert it between [EmbedFile] [/EmbedFile] tags, like this:
Once you submit your post, it will look like this!
I have also added a set of [EmbedItem] [/EmbedFile] tags if you'd like to show just a specific item from your file. (A defined range, pivot table or chart, for example.)
The method to get your iFrame code is the same as above. The code below comes from a file that has a chart named "Chart 1":
With tags it would look like this:
<iframe src="http://r.office.microsoft.com/r/rlidExcelEmbed?su=-8493146133887032856&Fi=SD8A224897002E61E8!265&AllowInteractivity=False" width="402" height="346" frameborder="0" scrolling="no"></iframe>
And when used would yield:
I will be writing up some articles on how to use Windows Live SkyDrive and the Excel WebApp over the next while. Hopefully you can find this useful!