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
No comments:
Post a Comment