Widget talk:Google Spreadsheet - Revision history

Celery: Protected "Widget talk:Google Spreadsheet" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite))

2015-03-31T19:02:32Z

Protected "Widget talk:Google Spreadsheet" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite))

Celery at 18:49, 31 March 2015

2015-03-31T18:49:09Z

Celery at 18:46, 31 March 2015

2015-03-31T18:46:49Z

Celery: 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: {{#widget:{{..."

2015-03-31T18:42:46Z

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>{{..."

New page

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>{{PAGENAME}}<nowiki>
|key=po-s58YMwf85Q3UxRzdGOBw
|width=500
|height=300
}}</nowiki>

@@ 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.

← Older revision		Revision as of 18:46, 31 March 2015
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 visible to the public.
		+
		+	* Height and Width values may be modified to suit your page design.

← Older revision	Revision as of 19:02, 31 March 2015
(No difference)