Help:Widget:Google Spreadsheet: Difference between revisions
(update demo with usage instructions) |
(add related widgets section) |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== What is | == What is Widget:Google Spreadsheet? == | ||
The Google Spreadsheet widget allows you to add '''[http://documents.google.com/support/spreadsheets/ Google Spreadsheets]''' to your articles on MozillaWiki. | The Google Spreadsheet widget allows you to add '''[http://documents.google.com/support/spreadsheets/ Google Spreadsheets]''' to your articles on MozillaWiki. | ||
| Line 8: | Line 8: | ||
To use this widget to insert your spreadsheet into your page, use the following code: | To use this widget to insert your spreadsheet into your page, use the following code: | ||
<nowiki>{{#widget:Google Spreadsheet | <nowiki>{{#widget:Google Spreadsheet | ||
|key=<id of google spreadhsheet> | |key=<id of google spreadhsheet> | ||
|width=<width in pixels> | |width=<width in pixels> | ||
| Line 15: | Line 15: | ||
=== Parameters === | === Parameters === | ||
* '''key''' | * '''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''' define spreadsheet dimensions, in pixels. 500x300 is default | * '''width''' and '''height''': These define spreadsheet dimensions, in pixels. 500x300 is default. | ||
* '''page''' | * '''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. | 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...''' | |||
[[File:Google_Spreadsheet_-_publish_step_1.png|300px]] | |||
'''Step 2:''' You will see the '''Publish to the web''' dialog. Change any settings you like and then click '''Publish''' button. | |||
[[File:Google_Spreadsheet_-_publish_step_2.png|400px]] | |||
'''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: | |||
[[File:Google_Spreadsheet_-_publish_step_3.png]] | |||
You can also get this id from the url of your spreadsheet: | |||
[[File:Google_Spreadsheet_Key_from_url.png]] | |||
== Real Example == | |||
The follow code embeds the spreadsheet you see below: | |||
<nowiki>{{#widget:Google Spreadsheet | |||
|key=1SbMo-k6Z6wYVrqwNHzhITMe1sSkDVCHYE_P2QA98_5k | |||
|width=500 | |||
|height=250 | |||
}}</nowiki> | |||
{{#widget:Google Spreadsheet | {{#widget:Google Spreadsheet | ||
| Line 29: | Line 53: | ||
|height=250 | |height=250 | ||
}} | }} | ||
== Related Widgets == | |||
* [[Help:Widget:Google Document]] | |||
* [[Help:Widget:Google Presentation]] | |||
* [[Help:Widget:Google Calendar]] | |||
Latest revision as of 05:12, 30 January 2015
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...
Step 2: You will see the Publish to the web dialog. Change any settings you like and then click Publish button.
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:
You can also get this id from the url of your spreadsheet:
Real Example
The follow code embeds the spreadsheet you see below:
{{#widget:Google Spreadsheet
|key=1SbMo-k6Z6wYVrqwNHzhITMe1sSkDVCHYE_P2QA98_5k
|width=500
|height=250
}}