Difference between revisions of "Widget talk:Google Spreadsheet"

From Multiverse Crisis MUSH
Jump to: navigation, search
Line 27: Line 27:
 
}}
 
}}
  
Keep these tips in mind when using this widget.
+
'''Keep these tips in mind when using this widget:'''
  
* Your Google Spreadsheet must be visible to the public.
+
* 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.
 
* Height and Width values may be modified to suit your page design.

Revision as of 18:49, 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.