Difference between revisions of "Widget talk:Google Spreadsheet"

From Multiverse Crisis MUSH
Jump to: navigation, search
(Created page with "To use this Widget, include this code in your wiki page, replacing the "key" value with the identifying value from your Google Spreadsheet URL: <nowiki>{{#widget:</nowiki>{{...")
 
m (Protected "Widget talk:Google Spreadsheet" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)))
 
(2 intermediate revisions by the same user not shown)
Line 6: Line 6:
 
|height=300
 
|height=300
 
}}</nowiki>
 
}}</nowiki>
 +
 +
Let's use the Music of the Multiverse spreadsheet as an example. URL: https://docs.google.com/spreadsheets/d/11aWp3I0pZHfshQv4pOKKQZJGJ0_gXBaHte0MxadzPb4/edit?usp=sharing
 +
 +
The "key" in the URL is this string: '''11aWp3I0pZHfshQv4pOKKQZJGJ0_gXBaHte0MxadzPb4'''
 +
 +
To embed in my wiki page, I would include the following code:
 +
 +
<nowiki>{{#widget:</nowiki>{{PAGENAME}}<nowiki>
 +
|key=11aWp3I0pZHfshQv4pOKKQZJGJ0_gXBaHte0MxadzPb4
 +
|width=500
 +
|height=300
 +
}}</nowiki>
 +
 +
Inserting the code yields these results:
 +
 +
{{#widget:Google Spreadsheet
 +
|key=11aWp3I0pZHfshQv4pOKKQZJGJ0_gXBaHte0MxadzPb4
 +
|width=500
 +
|height=300
 +
}}
 +
 +
'''Keep these tips in mind when using this widget:'''
 +
 +
* Your Google Spreadsheet must be published to the web before it will appear. Within Google Docs, go to File -> Publish to the Web -> Embed -> Publish. (Doing this makes your document visible to the public, but if you ever want to hide something later, you can return to the same menu to unpublish.)
 +
 +
* Height and Width values may be modified to suit your page design.

Latest revision as of 19:02, 31 March 2015

To use this Widget, include this code in your wiki page, replacing the "key" value with the identifying value from your Google Spreadsheet URL:

{{#widget:Google Spreadsheet
|key=po-s58YMwf85Q3UxRzdGOBw
|width=500
|height=300
}}

Let's use the Music of the Multiverse spreadsheet as an example. URL: https://docs.google.com/spreadsheets/d/11aWp3I0pZHfshQv4pOKKQZJGJ0_gXBaHte0MxadzPb4/edit?usp=sharing

The "key" in the URL is this string: 11aWp3I0pZHfshQv4pOKKQZJGJ0_gXBaHte0MxadzPb4

To embed in my wiki page, I would include the following code:

{{#widget:Google Spreadsheet
|key=11aWp3I0pZHfshQv4pOKKQZJGJ0_gXBaHte0MxadzPb4
|width=500
|height=300
}}

Inserting the code yields these results:

Keep these tips in mind when using this widget:

  • Your Google Spreadsheet must be published to the web before it will appear. Within Google Docs, go to File -> Publish to the Web -> Embed -> Publish. (Doing this makes your document visible to the public, but if you ever want to hide something later, you can return to the same menu to unpublish.)
  • Height and Width values may be modified to suit your page design.