Blogging just got better!

  • Article

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

  1. You can have the whole sheet viewable.
  2. You can share a specific range of cells.
  3. 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.