gspread
gspread copied to clipboard
Google Sheets Python API
## Overview rework the signature of the method `Worksheet.sort` to expose the expected parameters. ## Details The method `Worksheet.sort` uses some signature style that hides the possible argument for the...
**Is your feature request related to a problem? Please describe.** After copying a spreadsheet using client.copy and then opening the new sheet using client.open, the protected ranges are still correctly...
I tried using `batch_get` to collect values in a single call: ``` sheet = client.open_by_key('XXXXXXXXXXXXXXXXXXXXXXXX') print(sheet.batch_get(["'Page 1'!A1:A5","'Page 2'!A1:A5"])) ``` But I realized that it only accepts by setting the desired...
- _**Is your feature request related to a problem? Please describe.**_ - Accessing a sheet which is designated as public data with Oauth causes rate limit due to multiple users....
Greetings! I don't want to submit a bug. I just want to thank you GSPread team. Thanks for developing this open source project. have great times in your life &...
The date_time_render_option arguments are all string enums like value_render_option, it should also be a Python enum. [See docs](https://developers.google.com/sheets/api/reference/rest/v4/DateTimeRenderOption)
Fixes #1041 I removed the method, the according test and also run the tests, the format command and the lint command so everything seems to be in order. I am...
## Overview remove the deprecated method `Worksheet.delete_row` this method has been marked a deprecated since v3.5.0
## Overview as mentioned in #1032 the authentication flow using `console_flow` has been deprecated by google and should be removed. Any code related to it can be removed, we can...
## Overview Add method to split text from a single column into multiple columns. ## Details The api provide a way to split text from a single column into multiple...