Embed editable Google Docs spreadsheet without header & toolbar
Try adding rm=minimal
as in:
https://docs.google.com/spreadsheet/ccc?key=0AngcQK0IFROwdHZySkUwd0JtY0N6Zk5RaTAyZDFVekE&rm=minimal
The answer provided by Henrique requires a slight adjustment to work with the new Sheets.
Add ?rm=minimal
to the end of your document's URL, i.e.
https://docs.google.com/spreadsheets/d/1zHZdAImcjI4gAy5ATBA0rSImYUowL4HC8h-vvYOdpfA/edit?rm=minimal
Try these parameters, as described here:
single – setting to true displays just one sheet in the spreadsheet. The default sheet it will display is the first one created in the spreadsheet. This can be changed using ‘gid’ below.
gid – this needs to be a numeric identifier of the sheet you want to display. The first sheet created is 0, but others will have longer identifiers. To find the ‘gid’ for the sheet you want to display, go to the spreadsheet in Google Apps itself, and click on to your desired sheet. The URL in your browser should change to something like this:
https://docs.google.com/a/mycompany.com/spreadsheets/d/15B___SOYjsRmU9tiwZly318HZnFHOHeayS6UTHx7Pu2I/edit#gid=419657423
The bit at the end of the URL shows you the
gid
for the sheet, and that is the number you need to bring into the shortcode in your website.range – set this to the cell range you want to display within the sheet (or leave it out to display the whole sheet). In our example, we set this to
f2:g6
. Note if you’re being pedantic then you should really change the:
to%3A
since colons should be encoded in URLs – but most browsers should understand the colon, so don’t worry. If you like to be correct, you’d userange=f2%3Ag6
instead.headers – setting this to false hides the row numbers and column letters.
widget – setting this to false removes the sheet selector bar when it’s embedded.
chrome – setting this to false removes the title bar showing the spreadsheet name, above the sheet.
So putting it all together:
iframe src="https://docs.google.com/spreadsheets/d/[Googlekey]/pubhtml?gid=28&range=a1:s45&single=true&widget=true&headers=false"