Help:Widget:Google Spreadsheet

From MozillaWiki
Jump to: navigation, search

What is Widget:Google Spreadsheet?

The Google Spreadsheet widget allows you to add Google Spreadsheets to your articles on MozillaWiki.

It was originally created by Sergey Chernyshev for Semantic Communities LLC.

How do I use it?

To use this widget to insert your spreadsheet into your page, use the following code:

{{#widget:Google Spreadsheet |key=<id of google spreadhsheet> |width=<width in pixels> |height=<height in pixels> }}

Parameters

  • key: Key (id) of the document you want to embed. You can get this from the url of your Google Spreadsheet. Required.
  • width and height: These define spreadsheet dimensions, in pixels. 500x300 is default.
  • page:

Publishing your Google Spreadsheet

In order for the spreadsheet to be visible to all users of the wiki, you'll need to set permissions accordingly on the Google spreadsheet that you want to share.

Step 1: In your Google Spreadsheet, click File > Publish to the web...

Google Spreadsheet - publish step 1.png

Step 2: You will see the Publish to the web dialog. Change any settings you like and then click Publish button.

Google Spreadsheet - publish step 2.png

Step 3: The Publish to the web dialog will be updated with the public link or embed to your spreadsheet. You'll need the spreadsheet key that's part of this link. It looks like this:

Google Spreadsheet - publish step 3.png

You can also get this id from the url of your spreadsheet:

Google Spreadsheet Key from url.png

Real Example

The follow code embeds the spreadsheet you see below:

{{#widget:Google Spreadsheet |key=1SbMo-k6Z6wYVrqwNHzhITMe1sSkDVCHYE_P2QA98_5k |width=500 |height=250 }}

Related Widgets