Blogging just got better!
I found an email in my inbox today showing me how to share Excel sheets and presentations on blogs!
https://office.microsoft.com/en-us/excel/embed-an-excel-spreadsheet-on-a-web-page-FX102602477.aspx
I’ll try it out right now…
I looked through this to customize what shows up in the window…Learn how to customize your embedded Excel workbook
So firstly to get things viewable, you need to understand 2 things
- You can have the whole sheet viewable.
- You can share a specific range of cells.
- You may share an object (like a chart or pivot table).
I had a bit of a tough time coz I wanted to share a table range and a chart. To share the table name I had to go back to the sheet and ensure that it had a defined name. Name Manager in the formulas tab. Read more here.
Since my chart had a space character and despite trying to rename it in excel, the name wouldn’t change, I had to look up how to refer to the space character (%20) – read more here.
So here are what my tags look like…
<iframeheight="160" src="https://r.office.microsoft.com/r/rlidExcelEmbed?su=1420144883323114991&Fi=SD13B55E3F441015EF!1143&Item=MyChart&AllowInteractivity=False" frameborder="0" width="380" scrolling="no"></iframe>
<iframeheight="160" src="https://r.office.microsoft.com/r/rlidExcelEmbed?su=1420144883323114991&Fi=SD13B55E3F441015EF!1143&Item=Chart%201&AllowInteractivity=False" frameborder="0" width="490" scrolling="no"></iframe>
I had to fiddle with the iframes width and height.