canmove, Confirmed users, Bureaucrats and Sysops emeriti
3,698
edits
Help:Widget:Google Spreadsheet: Difference between revisions
Jump to navigation
Jump to search
Help:Widget:Google Spreadsheet (view source)
Revision as of 22:35, 29 January 2015
, 29 January 2015update with screen captures
(made code blocks code blocks) |
(update with screen captures) |
||
| 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 === | === Real Example === | ||