Monday, October 13, 2014

yogi_Using Google New Sheets Publish A Single Sheet With Only Specific Range

                 Google Spreadsheet   Post  #1794
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-13-2014
post by  Yogi Anand:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/docs-community/windows/chrome-browser/8OdvrBH5-5E)

Using Google New Sheets  Publish A Single Sheet with only Specific Range

first I got the following iframe code for a Single Sheet ... in this case Sheet1

iframe src="https://docs.google.com/spreadsheets/d/1vcaem1mo1cgN8tYaOx_XPrkRvsQfA53fkq9PAboj_08/pubhtml?gid=917838879&single=true&widget=true& amp;headers=false">/iframe>
(without showing the opening (left angle bracket) left of iframe and /iframe)

then to ask for publishing only A2:Q14, I added
range=A2%3AQ14&anp;
change that anp to amp
into the iframe code shown in the preceding as shown below

iframe width=830 height=600 src="https://docs.google.com/spreadsheets/d/1vcaem1mo1cgN8tYaOx_XPrkRvsQfA53fkq9PAboj_08/pubhtml?gid=917838879&single=true&widget=false&range=A2%3AQ14&headers=true">/iframe>
(again without showing the opening (left angle bracket) left of iframe and /iframe)

 so here we have it ... a WorkAround for Publishing a Single Sheet with a Specific Range