Difference between revisions of "Widget:Google Spreadsheet"

From AIE Wiki
Jump to: navigation, search
m (Created page with '<noinclude>__NOTOC__ This widget allows you to add '''[http://documents.google.com/support/spreadsheets/ Google Spreadsheets]''' to your wiki page. It was originally created by …')
 
Line 1: Line 1:
 
<noinclude>__NOTOC__
 
<noinclude>__NOTOC__
 
This widget allows you to add '''[http://documents.google.com/support/spreadsheets/ Google Spreadsheets]''' to your wiki page.
 
This widget allows you to add '''[http://documents.google.com/support/spreadsheets/ Google Spreadsheets]''' to your wiki page.
 +
* Created by [https://www.mediawikiwidgets.org/User:Sergey_Chernyshev Sergey Chernyshev]
 +
* Since Google Docs migrated to Google Drive, the reference for the template code has change. The latest is available [http://wiki.glitchdata.com/index.php?title=Widget:Google_Spreadsheet here].
  
It was originally created by [[mediawikiwiki:User:Sergey Chernyshev|Sergey Chernyshev]] for [http://www.semanticcommunities.com/ Semantic Communities LLC.]
+
== Using this widget ==
 +
For information on how to use this widget, see [https://www.mediawikiwidgets.org/Google_Spreadsheet widget description page on MediaWikiWidgets.org].
  
To insert this widget, use the following code:
+
== Copy to your site ==
 
+
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}}'''.
<nowiki>{{#widget:</nowiki>{{PAGENAME}}<nowiki>
+
</noinclude><includeonly><iframe width="<!--{$width|escape:'html'|default:500}-->" height="<!--{$height|escape:'html'|default:300}-->" frameborder="0" src="//spreadsheets.google.com/pub?key=<!--{$key|escape:'urlpathinfo'}--><!--{if not $page}-->&output=html&widget=true<!--{/if}-->"></iframe></includeonly>
|key=po-s58YMwf85Q3UxRzdGOBw
+
|width=500
+
|height=300
+
}}</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.)
+
 
+
{{Template:Copy to your site}}
+
 
+
== Related widgets ==
+
* [[Widget:Google Document|Google Document]] - for embedding documents
+
* [[Widget:Google Form|Google Form]] - for embedding spreadsheet forms
+
* [[Widget:Google Presentation|Google Presentation]] - for embedding presentations
+
 
+
== Sample result ==
+
{{#widget:{{PAGENAME}}
+
|key=po-s58YMwf85VdL_dX0w3VQ
+
|width=100%
+
|height=300
+
|page=true
+
}}
+
</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>
+

Revision as of 17:48, 3 January 2017

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.

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.