Difference between revisions of "Widget:Google Spreadsheet"

From Wazeopedia
(Annulation des modifications 14540 de Deeploz (discussion))
 
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]
+
* 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].
 
* 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].
  
 
== Using this widget ==
 
== Using this widget ==
For information on how to use this widget, see [https://www.mediawikiwidgets.org/Google_Spreadsheet widget description page on MediaWikiWidgets.org].
+
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 [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}}'''.
+
 
</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>
+
 
 +
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>

Latest revision as of 14:40, 2 May 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.

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

Sample result