pygsheets
pygsheets copied to clipboard
nithinmurali
exceeds grid limits. Max rows: 2280, max columns: 178 #124
From the comments it seems I am facing the same issue even though it is marked as resolved. I am using pip installed version 2.0.5
File "/Users/mapeterson/git/automation-audit/venv/lib/python3.7/site-packages/pygsheets/worksheet.py", line 1465, in get_as_df value_render=value_render, include_tailing_empty_rows=include_tailing_empty_rows) File "/Users/mapeterson/git/automation-audit/venv/lib/python3.7/site-packages/pygsheets/worksheet.py", line 494, in get_all_values include_tailing_empty_rows=include_tailing_empty_rows, **kwargs) File "/Users/mapeterson/git/automation-audit/venv/lib/python3.7/site-packages/pygsheets/utils.py", line 180, in wrapper return method(self, *args, **kwargs) File "/Users/mapeterson/git/automation-audit/venv/lib/python3.7/site-packages/pygsheets/worksheet.py", line 356, in get_values date_time_render_option=date_time_render_option, **kwargs) File "/Users/mapeterson/git/automation-audit/venv/lib/python3.7/site-packages/pygsheets/client.py", line 235, in get_range date_time_render_option) File "/Users/mapeterson/git/automation-audit/venv/lib/python3.7/site-packages/pygsheets/sheet.py", line 419, in values_get return self._execute_requests(request) File "/Users/mapeterson/git/automation-audit/venv/lib/python3.7/site-packages/pygsheets/sheet.py", line 495, in _execute_requests response = request.execute(num_retries=self.retries) File "/Users/mapeterson/git/automation-audit/venv/lib/python3.7/site-packages/googleapiclient/_helpers.py", line 131, in positional_wrapper return wrapped(*args, **kwargs) File "/Users/mapeterson/git/automation-audit/venv/lib/python3.7/site-packages/googleapiclient/http.py", line 937, in execute raise HttpError(resp, content, uri=self.uri) googleapiclient.errors.HttpError: <HttpError 400 when requesting https://sheets.googleapis.com/v4/spreadsheets/1gwbN3bLIjG-m2WPlsa7E0kmQGnALog8EObBg8BcGVOc/values/CSR2?majorDimension=ROWS&valueRenderOption=FORMATTED_VALUE&dateTimeRenderOption=SERIAL_NUMBER&alt=json returned "Range (user_map!CSR2) exceeds grid limits. Max rows: 432, max columns: 68". Details: "Range (user_map!CSR2) exceeds grid limits. Max rows: 432, max columns: 68">
@mapeterson The fix for this issue is merged to trunk but is not released. Can you please install pygsheets from GitHub and verify if that fixed your issue?
pip install https://github.com/nithinmurali/pygsheets/archive/staging.zip didn't help
Hmm, strange.
what is the name of your sheet, and size of the sheet.
Does running wks.get_all_values() throw the same error?
Try changing name of the sheet and check if its working. Try accessing some other sheets and check if its working.
Looks like it may be unique to that sheet. I have other sheets that end in a digit and they work fine. I didn't rename the sheet, but I did make a duplicate and called it "CSR2 Copy" and wks.get_all_values() worked. I then made another duplicate and named it to "CSR2 Copy2" and it also worked. But reloading CSR2 gave the same results. The dimensions are 130x26
Hmm, pretty strange. Unless i can reproduce this issue, I wont be able to help. if the data on that sheet is not private (and if you dont mind sharing it). Please share it to [email protected] or imnmfotmal(at)gmail.com.