Widget:Google Spreadsheet View history

Latest revision as of 08:20, 5 December 2014

This widget allows you to add Google Spreadsheets to your wiki page.

Created by Sergey Chernyshev
Since Google Docs migrated to Google Drive, the reference for the template code has change. The latest is available here.

Using this widget

For information on how to use this widget, see widget description page on MediaWikiWidgets.org.

Sample use

To insert this widget, use the following code:

{{#widget:Google Spreadsheet
|key=1HDGWluj1ffehMekq2I6E3GaFthQanMhbi6_2fj1xe-c
|width=100%
|height=300
|page=true
}}

Parameters

key - key parameter in document URL
width and height define spreadsheet dimensions, 500x300 is default, but you might want to copy it from embed code since size depends on fields you have
page - set it to embed whole page with edit links and more.

Security NOTE

Keep in mind that to use this widget you must make the document you're publishing to be open for everybody to see which might be undesirable for some uses (intranets, closed groups and etc.)

@@ Line 7: / Line 7: @@
 For information on how to use this widget, see [http://www.mediawikiwidgets.org/Google_Spreadsheet widget description page on MediaWikiWidgets.org].
-== Copy to your site ==
+== Sample use ==
-To use this widget on your site, just install [http://www.mediawiki.org/wiki/Extension:Widgets MediaWiki Widgets extension] and copy [{{fullurl:{{FULLPAGENAME}}|action=edit}} full source code] of this page to your wiki as '''{{FULLPAGENAME}}''' article.
-</noinclude><includeonly><iframe width="<!--{$width|escape:'html'|default:500}-->" height="<!--{$height|escape:'html'|default:300}-->" frameborder="0" src="http://spreadsheets.google.com/pub?key=<!--{$key|escape:'urlpathinfo'}--><!--{if not $page}-->&output=html&widget=true<!--{/if}-->"></iframe></includeonly>
+To insert this widget, use the following code:
+ <nowiki>{{#widget:</nowiki>{{PAGENAME}}<nowiki>
+|key=1HDGWluj1ffehMekq2I6E3GaFthQanMhbi6_2fj1xe-c
+|width=100%
+|height=300
+|page=true
+}}</nowiki>
+== Parameters ==
+* '''key''' - key parameter in document URL
+* '''width''' and '''height''' define spreadsheet dimensions, 500x300 is default, but you might want to copy it from embed code since size depends on fields you have
+* '''page''' - set it to embed whole page with edit links and more.
+== Security NOTE ==
+Keep in mind that to use this widget you must make the document you're publishing to be open for everybody to see which might be undesirable for some uses (intranets, closed groups and etc.)
+== Sample result ==
+{{#widget:{{PAGENAME}}
+|key=1HDGWluj1ffehMekq2I6E3GaFthQanMhbi6_2fj1xe-c
+|width=100%
+|height=300
+|page=true
+}}
+</noinclude><includeonly><iframe width="<!--{$width|escape:'html'|default:500}-->" height="<!--{$height|escape:'html'|default:300}-->" frameborder="0" src="https://docs.google.com/spreadsheet/ccc?key=<!--{$key|escape:'urlpathinfo'}--><!--{if not $page}-->&output=html&widget=true<!--{/if}-->">
+</iframe>
+</includeonly>