Sunday, 20 March 2016

Tips to Embed Google Spreadsheets

Google Docs is an web-based office suite including spreadsheet, word processing and presentation programs. Google Docs spreadsheets can be embedded in other web pages, such as personal blogs and Google Sites pages. Users that load your web page will see the spreadsheet's cells embedded and have read-only access to the spreadsheet; they can't edit it on the web page.

Log into your Google Docs account, and open a spreadsheet by clicking its name.

Click the down arrow to the right of "Share" at the top right corner of the spreadsheet, and click "Publish as a Web Page."

Select which sheets to embed by clicking the "Sheets to Publish" box. Sheets appear as tabs at the bottom of the Google spreadsheet web page; spreadsheets only have a single sheet by default.

Select whether to update the embedded spreadsheet when you change the original by clicking the "Automatically Republish When Changes Are Made" check box.

Click "Start Publishing."

Click the box under "Get a Link to The Published Data," and click "HTML to Embed In a Page."

Select the HTML code beginning with "<iframe" in the bottom box with your mouse, right-click the selected text, and click "Copy."

Paste the HTML code into your blog or other web page; the spreadsheet will appear in an embedded iframe on the web page. Iframes, or inline frames, embed web pages inside other web pages. In this case, the Google spreadsheet's public web page appears embedded. See your blog or other website software's documentation for information about inserting HTML code.

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Affiliate Network Reviews