Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Access named ranges from a spreadSheet not from a sheet. #876

Closed
lavigne958 opened this issue May 17, 2021 · 0 comments · Fixed by #941
Closed

Access named ranges from a spreadSheet not from a sheet. #876

lavigne958 opened this issue May 17, 2021 · 0 comments · Fixed by #941

Comments

@lavigne958
Copy link
Collaborator

Is your feature request related to a problem? Please describe.
NamedRanges are not tight to a particular sheet object, one could create a function that returns a list of Cell objects
obtained from only a given namedRange access via an instance of SpreadSheet without having to first get any WorkSheet.

Describe the solution you'd like
Create a new function (likely named namedRange) to get the content of a namedRange

Describe alternatives you've considered
get the first sheet and then get the namedRange, regardless if it is located on the first sheet ot not.

Additional context
From the API v4: only the spreadSheetID and the namedRange name is required to obtain the content
https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant