Difference between revisions of "Widget:Google Spreadsheet"

From EUSwiki
Jump to: navigation, search
 
Line 1: Line 1:
 +
<noinclude>__NOTOC__
 +
This widget allows you to add '''[https://support.google.com/docs/answer/37579?hl=de&ref_topic=2818999 Google Spreadsheets]''' to your wiki page.
  
It was originally created by [[mediawikiwiki:User:Sergey Chernyshev|Sergey Chernyshev]] and last updated by [[mediawikiwiki:User:Karsten Hoffmeyer|Karsten Hoffmeyer]].
+
Created by [https://www.mediawikiwidgets.org/User:Sergey_Chernyshev Sergey Chernyshev], last updated by [https://www.wikihoster.net Karsten Hoffmeyer].  
  
To insert this widget, use the following code:
+
== Using this widget ==
 +
For information on how to use this widget, see [https://www.mediawikiwidgets.org/Google_Spreadsheet widget description page on MediaWikiWidgets.org].
  
<nowiki>{{#widget:</nowiki>{{PAGENAME}}<nowiki>
+
== Copy to your site ==
|key=1oDnQlJ3eQ0ZOzmRiR8qkvEtSyEXaE32AyytUu6BMzRQ
+
To use this widget on your site, just install [https://www.mediawiki.org/wiki/Extension:Widgets MediaWiki Widgets extension] and copy the [{{fullurl:{{FULLPAGENAME}}|action=edit}} full source code] of this page to your wiki as page '''{{FULLPAGENAME}}'''.
|width=600
+
</noinclude><includeonly><iframe width="<!--{$width|escape:'html'|default:600}-->" height="<!--{$height|escape:'html'|default:400}-->" style="border: none" src="//docs.google.com/spreadsheets/d/<!--{$key|escape:'urlpathinfo'}-->/pubhtml?widget=true&amp;headers=false"></iframe></includeonly>
|height=400
 
}}</nowiki>
 
 
 
== Parameters ==
 
* '''key''' - key parameter in document URL
 
* '''width''' and '''height''' define spreadsheet dimensions, 600x400 is default, but you might want to copy it from embed code since size depends on fields you have
 
 
 
== 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.)
 
 
 
== Related widgets ==
 
* [[Widget:Google Document]] - for embedding documents
 
* [[Widget:Google Form]] - for embedding spreadsheet forms
 
* [[Widget:Google Presentation]] - for embedding presentations
 
 
 
== Sample result ==
 
{{#widget:{{PAGENAME}}
 
|key=1oDnQlJ3eQ0ZOzmRiR8qkvEtSyEXaE32AyytUu6BMzRQ
 
|width=600
 
|height=400
 
}}
 
{{Comments}}
 

Latest revision as of 05:49, 21 March 2018

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

Created by Sergey Chernyshev, last updated by Karsten Hoffmeyer.

Using this widget

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

Copy to your site

To use this widget on your site, just install MediaWiki Widgets extension and copy the full source code of this page to your wiki as page Widget:Google Spreadsheet.