Try the following: -
single - setting to true displays only one sheet in the spreadsheet. The default sheet that it displays is the first one created in the spreadsheet. This can be changed using the "gid below".
gid - this should be the 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 the sheet you need. The URL of your browser should change to something like this: https://docs.google.com/a/mycompany .com / spreadsheets / d / 15B ___ SOYjsRmU9tiwZly318HZnFHOHeayS6U thanks7Pu2I / edit # gid = 419657423
The bit at the end of the URL shows you the "gid for the worksheet" and this is the number you need to enter in the short code on your website.
Range
- set this to the range of cells that you want to display on the sheet (or leave it to display the entire sheet). In our example, we set this to f2: g6. Note that if you'rere pedantic, you should really change the ": to"% 3A, since the colons should be encoded in the urls, but most browsers should understand the colon, so don't worry. If you like to be true, you use the range = f2% 3Ag6 instead.
headers = false - Row and column numbers are not displayed.
widget - setting this value to false removes the sheet selection panel when it is inserted.
chrome - setting this value to false removes the title bar that displays the table name above the sheet.
So, all together: -
<iframe> src="https://docs.google.com/spreadsheets/d/[Googlekey]/pubhtml?gid=28&range=a1:s45&single=true&widget=true&headers=false" </iframe>
Allan
source share