pub= Publish Spreadsheet & Parameters


Published Spreadsheet & Parameters

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

HTML Format:

.../pub?output=html... 
Supports Sheet, Cell range , View

CSV Format:

.../pub?output=csv...
Supports Sheet, Cell range, Download Only

Pdf Format:

.../pub?output=pdf...
Supports Sheet,  Download Only

Sheet (ID)


...&gid=1...

Cell Range:


The range must be encoded

...&range=A1%3AD5...

or you can predefine a cell/cells range and call that specific range by name.

...&range=my_range01...


Cell Range View:

Displays Spreadsheet Title , Sheet Tab and all active Cells.

...&widget=true...



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