Difference between revisions of "Widget:Google Spreadsheet"

From Sugar Labs
Jump to navigation Jump to search
(update to include page parameter)
Line 9: Line 9:
  
 
  <nowiki>{{#widget:</nowiki>{{PAGENAME}}<nowiki>
 
  <nowiki>{{#widget:</nowiki>{{PAGENAME}}<nowiki>
|key=po-s58YMwf85Q3UxRzdGOBw
+
|key=0AlW_faI_kXyTdHVIX1dRYkhZc3JvWnB2bDZpLWpVQmc
 
|width=500
 
|width=500
 
|height=300
 
|height=300
|page=true .....(pending update)
+
|page=true
 
}}</nowiki>
 
}}</nowiki>
  
Line 31: Line 31:
 
}}
 
}}
  
</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'}-->&output=html&widget=true"></iframe></includeonly>
+
</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 15:55, 16 December 2010

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

It was originally created by Sergey Chernyshev for Semantic Communities LLC.

See http://www.mediawikiwidgets.org/Widget:Google_Spreadsheet and http://www.mediawikiwidgets.org/Google_Spreadsheet for usage instructions.

To insert this widget, use the following code:

{{#widget:Google Spreadsheet
|key=0AlW_faI_kXyTdHVIX1dRYkhZc3JvWnB2bDZpLWpVQmc
|width=500
|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