Embed an excel spread sheet in a web page.

I have a web site client who wants to use a simple calculator within a web page to allow his customers to calculate  a cost for total postage due. The client already had a spreadsheet with the calculation so the easy way was to embed that spreadsheet within his existing website.  In the past this would have been difficult to achieve but now , thanks to skydrive it is just a few mouse clicks.
Step 1:Go to SkyDrive and create a new account if you don’t already have one, and then create a public folder.

Step 2:Upload your spreadsheet to your public folder, and then open it in the Web App.
At the top of the page, click Share, and then choose Embed. In the dialog box, specify the data that you want to embed and customize how you want it to appear on your web page.

Step 3: At the bottom of the dialog box, click Copy to grab the embed code (or markup) and copy it to your Clipboard.
Step 4: The markup you copied from the Excel Web App page is an iframe tag, supported in many web authoring environments and blog services. Go to your blog editor, begin writing your post, then switch to HTML editing.

Step 5: Make sure the markup you copied is the most recent item in your Clipboard and press CTRL + V. There’s your embedded spreadsheet!

Your web visitors can now ineract with your spread sheet which will return to it’s original state once they sign out.


This entry was posted in Internet, Misc and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s