-
Notifications
You must be signed in to change notification settings - Fork 20
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
Requests to sheets API cause 400 error is worksheet name is valid cell reference (was: Error using get_as_dataframe) #54
Comments
Turns out that This apparently causes problems for the underlying call to So if a worksheet happens to have the name that is also a valid cell reference, such as I don't believe that it's gspread's fault -- the range argument to The solution will be to have https://developers.google.com/sheets/api/guides/concepts#a1_notation |
I am using get_as_dataframe to read a sheet. If the sheet name is "CRM26" the extraction fails with:
{'code': 400, 'message': 'Range (query!CRM26) exceeds grid limits. Max rows: 10002, max columns: 35', 'status': 'INVALID_ARGUMENT'}
If the sheet name is "CRM", "CR26M" or "CRM 26" the extraction is successful.
The text was updated successfully, but these errors were encountered: