I recently came across a Google Sheets that had a slightly different syntax in the URL. I found these tags after the Spreadsheet Key:
&single=true&gid=0&range=B5%3AB5&output=html
I experimented by putting each of these at the end of one of my docs and discovered some things changed as a result:
&single=true
&gid=0
&range=B5%3AB5
&output=html
I was particularly interested in &range=
. When I chose a regular range such as A1:B2
it also worked.
But why &range=B5%3AB5
?
What does it mean and how do I use it?
&range=B5%3AB5
is the same as&range=B5:B5
(url encoding) – neo Jul 4 '11 at 15:59&output=pdf
generates the sheet as a PDF. – bleater Dec 7 '15 at 5:05