Create Rich and Interactive Data Mashups with Excel
By on December 12th, 2011

Microsoft has launched a new service that allows developers to quickly create rich and interactive data mashups for their sites.

Microsoft Excel

Follow three easy steps to develop mashups with Microsoft Excel web App on SkyDrive using JavaScript:

  • Upload your workbook on SkyDrive
  • Embed it on your web site
  • Mash it up with our JavaScript API

Before you can embed your Excel workbook on a web page, you need to upload it a folder on SkyDrive and then set permissions on the workbook. Once   you have your workbook uploaded to SkyDrive, you can use the SkyDrive Embed dialog box to get the HTML and JavaScript code that will embed the workbook on a Web page. Now, you can use the Excel Services JavaScript library to make rich data mashups using data from your embedded workbook.

While the iframe code only displays the spreadsheet on a Web page, Microsoft Excel Web App also generates a JavaScript snippet that you can paste into the HTML of your web page alternatively. This JavaScript snippet consists of an HTML div element that displays the spreadsheet and a script element that sets options for appearance and interactivity. You can add your own code to programmatically manipulate the embedded spreadsheet.

Excel Mashup

Tags: , , , ,
Author: Abhishek Baxi
Abhishek Baxi is an independent technology columnist for several international publications and a digital consultant. He speaks incessantly on Twitter (@baxiabhishek) and dons the role of Editor-in-Chief here at Techie Buzz.

Abhishek Baxi has written and can be contacted at abhishek@techie-buzz.com.

Leave a Reply

Name (required)

Website (optional)

 
 
Copyright 2006-2012 Techie Buzz. All Rights Reserved. Our content may not be reproduced on other websites. Content Delivery by MaxCDN