Skip to content

Автоматическое расширение листа при экспорте #165

Description

@HadronCollider

сейчас может падать с

11:08:32     wk_content.set_dataframe(df=df, start=start_cell, copy_head=True, nan='')
11:08:32   File "/usr/local/lib/python3.12/site-packages/pygsheets/utils.py", line 214, in wrapper
11:08:32     return func(*args, **kwargs)
11:08:32            ^^^^^^^^^^^^^^^^^^^^^
11:08:32   File "/usr/local/lib/python3.12/site-packages/pygsheets/worksheet.py", line 1505, in set_dataframe
11:08:32     self.update_values(crange=crange, values=values)
11:08:32   File "/usr/local/lib/python3.12/site-packages/pygsheets/utils.py", line 214, in wrapper
11:08:32     return func(*args, **kwargs)
11:08:32            ^^^^^^^^^^^^^^^^^^^^^
11:08:32   File "/usr/local/lib/python3.12/site-packages/pygsheets/worksheet.py", line 706, in update_values
11:08:32     self.client.sheet.values_batch_update(self.spreadsheet.id, body, parse)
11:08:32   File "/usr/local/lib/python3.12/site-packages/pygsheets/sheet.py", line 374, in values_batch_update
11:08:32     self._execute_requests(request)
11:08:32   File "/usr/local/lib/python3.12/site-packages/pygsheets/sheet.py", line 496, in _execute_requests
11:08:32     response = request.execute(num_retries=self.retries)
11:08:32                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
11:08:32   File "/usr/local/lib/python3.12/site-packages/googleapiclient/_helpers.py", line 130, in positional_wrapper
11:08:32     return wrapped(*args, **kwargs)
11:08:32            ^^^^^^^^^^^^^^^^^^^^^^^^
11:08:32   File "/usr/local/lib/python3.12/site-packages/googleapiclient/http.py", line 938, in execute
11:08:32     raise HttpError(resp, content, uri=self.uri)
11:08:32 googleapiclient.errors.HttpError: <HttpError 400 when requesting https://sheets.googleapis.com/v4/spreadsheets/140Q97LUU45QrXQGnzIStdR3ZCG093z1ZsUp1HFR-Co8/values/%27Export%27%21A1924%3AAA3847?valueInputOption=USER_ENTERED&alt=json returned "Range (Export!A1924:AA3847) exceeds grid limits. Max rows: 1923, max columns: 26". Details: "Range (Export!A1924:AA3847) exceeds grid limits. Max rows: 1923, max columns: 26">

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions