Saturday, July 16, 2011

yogi_Embed A Sheet Of A Spreadsheet And Not Display The Sheet Number(Name)

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
fredvolkman said:
I would like to embed a spreadsheet into a web page without displaying the sheet number. Is there a way to tweak the code so that the sheet number is hidden?
You can publish contents from a sheet of a spreadsheet without displaying the sheet number(name) provided ...
1) you select only a single sheet
2) you select a specific range to be published
3) in the code generated to publish as an HTML page
you change from widget=true to widget=false

In the following illustration, I chose only Sheet3 and range A1:F2 of Sheet3 to be published ...