Difference between revisions of "Widget:Google Spreadsheet"

From ICPWiki
Jump to: navigation, search
(Sample result)
Line 1: Line 1:
<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/ Google Documents]''' to your wiki page.
+
* Created by [http://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 [http://www.mediawikiwidgets.org/Google_Spreadsheet widget description page on MediaWikiWidgets.org].
To insert this widget, use the following code:
 
 
 
<nowiki>{{#widget:</nowiki>{{PAGENAME}}<nowiki>
 
|key=1hhpWRL4oyH6Aqf42laXo_lElObX_1JiaV4FMt8llA_U
 
|width=500
 
|height=300
 
}}</nowiki>
 
 
 
== Parameters ==
 
* '''width''' and '''height''' define document dimensions, 500x300 is default
 
* '''key''' - key parameter in emailing/embedding URL (<code><nowiki>http://docs.google.com/spreadsheets/d/</nowiki>'''key'''<nowiki>/pubhtml</nowiki></code>)
 
* '''frameborder''' defines the border of the embedded frame
 
 
 
; Note: In order for your embedded Google Doc to be visible on your wiki, you must first '''publish it to the web'''.
 
# Open your document.
 
# From the document menu, choose File > Publish to the Web...
 
# Click "Start publishing" button.
 
# See also: [http://support.google.com/docs/bin/answer.py?hl=en&answer=183965 Publishing does not affect visibility options]
 
 
 
== Sample result ==
 
{{#widget:{{PAGENAME}}
 
|key=1vUqIkKD1-WmZJ55Pm-h8R_VX6bnKoLydgz8G2ISprkY
 
|width=500
 
|height=300
 
|frameborder=3
 
}}
 
 
 
{{Template:Copy to your site}}
 
* Since Google Migration to Google Drive, the template reference has changed. See [http://wiki.glitchdata.com/index.php?title=Widget:Google_Document here] for latest template code.
 
 
 
== Related widgets ==
 
* [[Widget:Google Spreadsheet|Google Spreadsheet]] - for embedding spreadsheets
 
* [[Widget:Google Form|Google Form]] - for embedding spreadsheet forms
 
* [[Widget:Google Presentation|Google Presentation]] - for embedding presentations
 
  
 +
== Copy to your site ==
 +
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="<!--{$frameborder|escape:'html'|default:1}-->" src="http://docs.google.com/spreadsheets/d/<!--{$key|escape:'urlpathinfo'}-->/pubhtml?widget=true&amp;headers=false"></iframe></includeonly>
 
</noinclude><includeonly><iframe width="<!--{$width|escape:'html'|default:500}-->" height="<!--{$height|escape:'html'|default:300}-->" frameborder="<!--{$frameborder|escape:'html'|default:1}-->" src="http://docs.google.com/spreadsheets/d/<!--{$key|escape:'urlpathinfo'}-->/pubhtml?widget=true&amp;headers=false"></iframe></includeonly>

Revision as of 15:23, 10 April 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.

Copy to your site

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