0

I have a spreadsheet that contains a named range. How do I read the value of the referenced range from the api?
I have tried the

service.get_spreadsheet_values(doc_id, range)

example.
But if range is specified as 'myspecialrange' then I get

badRequest: Unable to parse range: 'REHTEST'

I've been using the getNamedRanges from the javascript APP scripting environment and now needs this from the Rest API.

Improve this question
2
  • I am not sure what your code look like, it seems that you specified the value of range in service.get_spreadsheet_values(doc_id, range) as REHTEST. Take note that doc_id must be the spreadsheet ID and the range is the cells, rows or columns where you will be getting a value, example, Sheet1!A1:A2. In this scenario you will be getting the value from the cells A1 to A2 located in the Sheet1 under to the spreadsheet ID you have specified. See this SO post. Commented May 15, 2018 at 9:40
  • I am aware of the use of the A1 notation. My problem is that the API states that you can use "named ranges" ... I don't know how to specify the named range and use this to get the value. Commented May 16, 2018 at 14:55
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.