Embedding Excel in a Website


Error message

  • Deprecated function: implode(): Passing glue string after array is deprecated. Swap the parameters in drupal_get_feeds() (line 394 of /homepages/10/d394373203/htdocs/puttingthedanindanger/includes/common.inc).
  • Deprecated function: The each() function is deprecated. This message will be suppressed on further calls in menu_set_active_trail() (line 2385 of /homepages/10/d394373203/htdocs/puttingthedanindanger/includes/menu.inc).
In a previous post, I showed you how to embed excel interactive tables. I will not link to it here, because unfortunately, that feature has now been deprecated. And that was a cool feature, why must you ruin everything I love Microsoft!? :) But I digress, what MS taketh so shall they provide and there is a new way to embed interactive visualizations using Excel! Yay! But... you have to use OneDrive. Sorry about that. However, it is really easy to do. In fact, I'm not even going to give a whole tutorial on it. Microsoft made this so easy that their documentation is perfectly sufficient to do it on your own. One quick note, you will generate the embedded workbook first, then decide which elements to publish. That feels a little backwards to me, but whatever. Here's quick example using data from the USDA's price of vegetables per cup: The data isn't pretty, I fix it up in a separate post using Tableau Public, but it give a great example of how you can take anything from an Excel workbook and slap it into a website, with interactivity! Source: http://www.ers.usda.gov/data-products/fruit-and-vegetable-prices/interactive-chart-costs-per-edible-cup-equivalent.aspx