I have a 400 row sheet embedded in a web page. I would like the header row to be frozen, as it is in the original sheet. So far I've been unable to discover any parameter to allows this, but also I've not been able to discover any source of current parameters.
On Google product forums there are various solutions, but so far all of the ones I've found predate the major changes in sheets that took place is 2013.
My current sheet is embedded as follows:
<iframe height='1000px' src="https://docs.google.com/spreadsheets /d/10u28L2gCe6wSdAZWwXRMZKi90M7dNYQrCcyE_QWEOZw/pubhtml?gid=1276723055 &single=true&widget=false&headers=false&rm=minimal"> </iframe>
I have added line breaks so that you don't need to scroll.
AFAIK widget=false/true no longer controls the appearance/disappearance of the file/sheet name. rm=minimal only works on link shared sheets. I've tried true, false and 1 for headers with no effect.
I would also like to strip column letters and row numbers, another feature that seems to have vanished at the UI change.
How can I keep my header rows in an embedded sheet?
Anyone have a link to the current parameters that an embedded sheet takes?