Private Spreadsheets:
The Google Spreadsheets system is completely upgraded from time to time, so be aware that many older parameters may have been
Depreciated fully.
If your spreadsheet is not published and you would like to publish a certain sheet and/or range.
In Google spreadsheets go to:
File > Publish to the Web... > Start Publishing
Published Spreadsheets:
Once your spreadsheet [specific sheet] is published, you can use the following parameters on the fly.
Publishing Formats:
Text Format:
.../pub?output=txt...
Supports Sheet, Cell range , View
.../pub?output=html...
Supports Sheet, Cell range , View
Supports Sheet, Cell range, Download Only
.../pub?output=pdf...
Supports Sheet, Download Only
Sheet (ID)
Cell Range:
The range must be encoded
or you can predefine a cell/cells range and call that specific range by name.
Cell Range View:
Displays Spreadsheet Title , Sheet Tab and
all active Cells.
When displaying a Cell range you can force the
widget=true parameter to display the cell range only.
...
&widget=true
&single=true...
Other Export Parameters
Some older parameters are now fully
Depreciated in the new Google Spreadsheets format.
Other parameters when exporting documents.
.../fm?id=...
.../Export?id=...
fmcmd=12
size=0
fzr=true
portrait=false
fitw=true
gridlines=false
printtitle=true
sheetnames=true
pagenum=CENTER
attachment=true
FLASH SWF / PDF Export [ Depreciated ]
Exporting presentations as Flash SWF has been removed.
...Export?docID=1234&exportFormat=swf
"We recommend clients currently using SWF exports switch to PDF exports, using the appropriate exportFormat value." - Official Google Apps Developers.
...Export?docID=1234&exportFormat=pdf
Full Spreadsheet in Html:
Add Spreadsheet HTML view to a Google Sites webpage:
Insert > document "Or paste a web address here:"
https://spreadsheets1.google.com/spreadsheet/pub?key=0AjU_rJcQHTNFdE9Iaml2Y0FzLTVfalZ5LW5mUWJsSkE&output=html
Spreadsheet HTML Range:
https://spreadsheets1.google.com/spreadsheet/pub?key=0AjU_rJcQHTNFdE9Iaml2Y0FzLTVfalZ5LW5mUWJsSkE&output=html&range=A1%3AD5
Publishing Formats for Feeds:
ATOM Format:
.../feeds/list/.../od6/public/basic...
.../feeds/cells/.../od6/public/basic...
Supports List, Cell range , View
RSS Format:
.../feeds/cells/.../od6/public/basic?&alt=rss...
.../feeds/cells/.../od6/public/basic?&alt=rss...
Supports List, Cell range , View
Spreadsheet RSS Example:
https://spreadsheets.google.com/feeds/cells/0AjU_rJcQHTNFdE9Iaml2Y0FzLTVfalZ5LW5mUWJsSkE/od6/public/basic?hl=en_US&alt=rss