Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I recently came across a Google Spreadsheet 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

My question is what are these and where do I find a list of all the options???

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?

Does anyone have documentation about what other display options exist?

share|improve this question
    
&range=B5%3AB5 is the same as &range=B5:B5 (url encoding) –  neo Jul 4 '11 at 15:59
add comment

2 Answers

The special characters are encoded using URL encoding. If you have to use special characters in the URL, you will need to encode them. You can use a web app such as this for doing the same.

share|improve this answer
add comment

This link has a few of the ones you mentioned and some you didn't

Reference Guide - Google Spreadsheets API - Google Code

some of the page is irrelevant to the question.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.