- update to 6.2.1:
* Fix public API auth snippet
* Clarify the first step: authentication
* Fix typo in community.rst
* rearrange flow to remove reference to creds
* switch safety for pip-audit
* Include the duplicate column names in error message
* Add property expiry in gspread client
* Bump typing-extensions from 4.11.0 to 4.12.0
* Fix code block formatting typo in README
* Type part of test suite utils
* Remove passing exception as args to super in APIError
* Fix docstring about BackOffHTTPClient
* Fix comment to reflect correct google-auth package version
requirement
* Doc/community addons orm package
* fix: fix type annotation for default_blank
* Bump mypy from 1.11.1 to 1.11.2
* better handler API error parsing.
* Add test on receiving an invalid JSON in the APIError
exception handler.
* [feature] Add 'expand_table' feature
* Created a batch_merge function [Issue #1473]
* Added a range option to Worksheet.get_notes [Issue #1482]
* Documentation update for
gspread.worksheet.Worksheet.get_all_records
* add example for batch_merge
* explicitly list exported package symbols
- update to 6.2.1:
OBS-URL: https://build.opensuse.org/request/show/1307735
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-gspread?expand=0&rev=18
* Fix public API auth snippet
* Clarify the first step: authentication
* Fix typo in community.rst
* rearrange flow to remove reference to creds
* switch safety for pip-audit
* Include the duplicate column names in error message
* Add property expiry in gspread client
* Bump typing-extensions from 4.11.0 to 4.12.0
* Fix code block formatting typo in README
* Type part of test suite utils
* Remove passing exception as args to super in APIError
* Fix docstring about BackOffHTTPClient
* Fix comment to reflect correct google-auth package version
requirement
* Doc/community addons orm package
* fix: fix type annotation for default_blank
* Bump mypy from 1.11.1 to 1.11.2
* better handler API error parsing.
* Add test on receiving an invalid JSON in the APIError
exception handler.
* [feature] Add 'expand_table' feature
* Created a batch_merge function [Issue #1473]
* Added a range option to Worksheet.get_notes [Issue #1482]
* Documentation update for
gspread.worksheet.Worksheet.get_all_records
* add example for batch_merge
* explicitly list exported package symbols
- update to 6.2.1:
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=35
- update to 6.1.2:
* add note about runnings tests to contrib guide
* Some updates on get_notes
* Add some missing typing in code
* More fixes for Worksheet.update argument ordering & single
cell updating (i.e. now Worksheet.update_acell)
* Added 'add_data_validation` to Workhsheet [Issue #1420]
* Fix incorrect version number in HISTORY.rst from 6.0.1 to
6.1.0
* add get_notes
* Bump mypy from 1.9.0 to 1.10.0
* bugfix: handle domain name in spreadsheet copy permissions
* Fix/api key auth version
* Ignore pip vulnerabilities in CI.
* Remove StrEnum dependency and added custom class[issue #1462]
OBS-URL: https://build.opensuse.org/request/show/1178157
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-gspread?expand=0&rev=16
* add note about runnings tests to contrib guide
* Some updates on get_notes
* Add some missing typing in code
* More fixes for Worksheet.update argument ordering & single
cell updating (i.e. now Worksheet.update_acell)
* Added 'add_data_validation` to Workhsheet [Issue #1420]
* Fix incorrect version number in HISTORY.rst from 6.0.1 to
6.1.0
* add get_notes
* Bump mypy from 1.9.0 to 1.10.0
* bugfix: handle domain name in spreadsheet copy permissions
* Fix/api key auth version
* Ignore pip vulnerabilities in CI.
* Remove StrEnum dependency and added custom class[issue #1462]
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=31
- update to 6.1.0:
* types can be obtained using mypy to type code using gspread
* Add a new method to authenticate using API key for public
spreadsheets
* Add py.typed marker
* Improve back-off client
* Add new auth method API key
* Bugfix/add set timeout
* Fix wrapper `cast_to_a1_notation`
* fix error message readability
* Add missing method `import_csv()`
* Add user friendly message when we can't override a test
cassette
* Allow "warning" type protected ranges
* Improce README and documentation with value render options
OBS-URL: https://build.opensuse.org/request/show/1167621
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-gspread?expand=0&rev=15
* types can be obtained using mypy to type code using gspread
* Add a new method to authenticate using API key for public
spreadsheets
* Add py.typed marker
* Improve back-off client
* Add new auth method API key
* Bugfix/add set timeout
* Fix wrapper `cast_to_a1_notation`
* fix error message readability
* Add missing method `import_csv()`
* Add user friendly message when we can't override a test
cassette
* Allow "warning" type protected ranges
* Improce README and documentation with value render options
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=29
* Allow client to use external Session object
* Remove-py-3.7-support
* bugfix/client export
* Fix oauth flow typo
* check oauth creds type using isinstance
* Fix type hints at find method in worksheet.py
* Fixup get empty cell value is None
* Fix missing attribute spreadsheet in Worksheet.
* update migration guide
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=27
- update to 6.0.0:
* Remove deprecated method delete_row
* Initial typing in client.py
* Split client http client
* Spelling fix & update docs with date_time_render_option
behaviour
* #966 Add sketch typing for utils.py
* Remove accepted_kwargs decorator
* Remplace named tuples with enums
* Feature/add type hints worksheets
* Implement hex color conversion
* remove lastUpdateTime
* Merge master into feature/release_6_0_0
* Add type checking to lint
* Warning/update swapped args
* Improve Worksheet.sort() signature
* Make get_values and alias of get
* fix type issue (remove .first() function)
* Remove/get records use index
* increase warning stacklevel from 1 to 2
* Feature/merge master
* feature/merge master
* Simplify get records
* Add util function to_records to build records
in https://github.com/burnash/gspread/pull/1377
* feature/add utils get records
* Add migration guide for get_all_records
* feature/merge master into release 6 0 0
* Feature/release 6 0 0
OBS-URL: https://build.opensuse.org/request/show/1142772
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-gspread?expand=0&rev=13
* Remove deprecated method delete_row
* Initial typing in client.py
* Split client http client
* Spelling fix & update docs with date_time_render_option
behaviour
* #966 Add sketch typing for utils.py
* Remove accepted_kwargs decorator
* Remplace named tuples with enums
* Feature/add type hints worksheets
* Implement hex color conversion
* remove lastUpdateTime
* Merge master into feature/release_6_0_0
* Add type checking to lint
* Warning/update swapped args
* Improve Worksheet.sort() signature
* Make get_values and alias of get
* fix type issue (remove .first() function)
* Remove/get records use index
* increase warning stacklevel from 1 to 2
* Feature/merge master
* feature/merge master
* Simplify get records
* Add util function to_records to build records
in https://github.com/burnash/gspread/pull/1377
* feature/add utils get records
* Add migration guide for get_all_records
* feature/merge master into release 6 0 0
* Feature/release 6 0 0
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=25
- update to 5.12.4:
* Fixed default value of merge_type parameter in merge_cells
function docstring.
* 1363 get all records retrieves a large number of empty rows
after the end of the data
* Many fixes for get_records
* change worksheet.update migration guide
* feature/readme migration v6
* add deprecation warnings for lastUpdateTime...
* remove use_index and references to it in get_records
* make deprecation warning dependent on if kwarg is used for
client_factory
* fix 1352 expected headers broken
* fix combine_merged_cells when using from a range that doesn't
start at A1
* feature -- adding worksheet.get_records to get specific row
ranges
* Fix list_spreadsheet_files return value
* Fix warning message for worksheet.update method
* change lambda function to dict (fix pyupgrade issue)
* allows users to silence deprecation warnings
* Add maintain_size to keep asked for size in get, get_values
* Fix list_spreadsheet_files return value by @mephinet in
* Fix merge_combined_cells in get_values (AND 5.11.2 RELEASE)
* remove Drive API access on Spreadsheet init (FIX - VERSION
5.11.1)
* add docs/build to .gitignore
* add release process to CONTRIBUTING.md
* add test_fill_gaps and docstring for fill_gaps
* Remove API calls from creationTime/lastUpdateTime
OBS-URL: https://build.opensuse.org/request/show/1138508
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-gspread?expand=0&rev=12
* Fixed default value of merge_type parameter in merge_cells
function docstring.
* 1363 get all records retrieves a large number of empty rows
after the end of the data
* Many fixes for get_records
* change worksheet.update migration guide
* feature/readme migration v6
* add deprecation warnings for lastUpdateTime...
* remove use_index and references to it in get_records
* make deprecation warning dependent on if kwarg is used for
client_factory
* fix 1352 expected headers broken
* fix combine_merged_cells when using from a range that doesn't
start at A1
* feature -- adding worksheet.get_records to get specific row
ranges
* Fix list_spreadsheet_files return value
* Fix warning message for worksheet.update method
* change lambda function to dict (fix pyupgrade issue)
* allows users to silence deprecation warnings
* Add maintain_size to keep asked for size in get, get_values
* Fix list_spreadsheet_files return value by @mephinet in
* Fix merge_combined_cells in get_values (AND 5.11.2 RELEASE)
* remove Drive API access on Spreadsheet init (FIX - VERSION
5.11.1)
* add docs/build to .gitignore
* add release process to CONTRIBUTING.md
* add test_fill_gaps and docstring for fill_gaps
* Remove API calls from creationTime/lastUpdateTime
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=23
- Update to version 5.7.1
* Fix dependencies required version by @lavigne958 in #1147
- Update to version 5.7.0
* chore: Update outdated LICENSE year by @bluzir in #1124
* add dependabot to maintain dependencies by @lavigne958 in #1126
* improve trigger on CI by @lavigne958 in #1134
* Bump bandit from 1.7.0 to 1.7.4 by @dependabot in #1133
* cancel previous run on same ref by @lavigne958 in #1135
* Bump actions/setup-python from 2 to 4 by @dependabot in #1127
* Bump actions/checkout from 2 to 3 by @dependabot in #1128
* Bump black from 22.3.0 to 22.10.0 by @dependabot in #1132
* Bump isort from 5.9.3 to 5.10.1 by @dependabot in #1131
* Bump codespell from 2.1.0 to 2.2.2 by @dependabot in #1130
* add named tuple for DateTimeRenderOption by @lavigne958 in #1136
* Feature/copy cut paste by @lavigne958 in #1138
* isSheetHidden method added to worksheet.py by @SazidAF in #1140
OBS-URL: https://build.opensuse.org/request/show/1039850
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=19
- 5.5.0 (2022-08-31)
Use pathlib by @lavigne958 in #1057
Migrate to drive API V3 by @lavigne958 in #1060
Implement __eq__ method for Cell by @chisvi in #1063
Add missing documentation on set_timeout by @lavigne958 in #1070
Add method to transfer / accept ownership of a spreadsheet by @lavigne958 in #1068
Add client_factory param to auth methods by @jlumbroso in #1075
Fix list_protected_ranges by @lavigne958 in #1076
Add function to convert column letter to column index by @lavigne958 in #1077
Fix docstring name of named_range() param by @dgilman in #1081
Fix grammar in docstring for client.export by @dgilman in #1080
Many typo fixes to worksheet docstrings by @dgilman in #1083
Fix function numericise_all by @lavigne958 in #1082
Fix documentation about oauth_from_dict by @lavigne958 in #1088
inherit_from_before option for insert_row/insert_rows by @yongrenjie in #1092
add method to change the color of a tab by @lavigne958 in #1095
docs: Fix a few typos by @timgates42 in #1094
Fix typo in Worksheet.batch_format method by @lavigne958 in #1101
## New Contributors * @chisvi made their first contribution in #1063 * @jlumbroso made their first contribution in #1075 * @yongrenjie made their first contribution in #1092
- 5.4.0 (2022-06-01)
fix typo by @joswlv in #1031
Fix error message in get_all_records by @lavigne958 in #1028
Added feature request #1022. Auto resizing is now available for rows … by @mketer1 in #1033
add new method to hide/show a worksheet by @lavigne958 in #1030
feat: Download PDF from Spreadsheet #1035 by @100paperkite in #1036
Add test on auto_resize_columns by @lavigne958 in #1039
Add method to unmerge cells by @lavigne958 in #1040
Add method to delete a protected range by @lavigne958 in #1042
Feature/clean organize documentation by @lavigne958 in #1043
Add warning about deprecated oauth flow by @lavigne958 in #1047
OBS-URL: https://build.opensuse.org/request/show/1006789
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=15
- Update to 3.7.0:
* Add `Worksheet.insert_note()`, `Worksheet.update_note()`, `Worksheet.clear_note()` (#818 by @lavigne958)
* Add `Worksheet.insert_cols()` (#802 by @AlexeyDmitriev)
* Add `value_render_option` parameter to `Worksheet.get_all_records()` (#776 by @damgad)
* Remove `requests` from `install_requires` (#801)
* Simplify implementation of `Worksheet.insert_rows()` (#799 by @AlexeyDmitriev)
* Add `auth.service_account_from_dict()` (#785 b7 @mahenzon)
* Fix `ValueRange.from_json()` (#791 by @erakli)
* Allow `auth` to be `None`. Fix#773 (#774 by @lepture)
* Add `Worksheet.insert_rows()` (#734 by @tr-fi)
* Add `Worksheet.copy_to()` (#758 by @JoachimKoenigslieb)
* Add ability to create a cell instance using A1 notation (#765 by @tivaliy)
* Add `auth.service_account()` (#768)
* Add Authlib usage (#552 by @lepture)
* Simplified OAuth2 flow (#762)
* Fix `Worksheet.delete_rows()` index error (#760 by @rafa-guillermo)
* Deprecate `Worksheet.delete_row()` (#766)
* Scope `Worksheet.find()` to a specific row or a column (#739 by @alfonsocv12)
* Add `Worksheet.add_protected_range()` #447 (#720 by @KesterChan01)
* Add ability to fetch cell address in A1 notation (#763 by @tivaliy)
* Add `Worksheet.delete_columns()` (#761 by @rafa-guillermo)
* Ignore numericising specific columns in `get_all_records` (#701 by @benjamindhimes)
* Add option ``folder_id`` when creating a spreadsheet (#754 by @Abdellam1994)
* Add `insertDataOption` to `Worksheet.append_row()` and `Worksheet.append_rows()` (#719 by @lobatt)
* Fix `TypeError` when using gspread in google colab (#750)
* Remove `oauth2client` in favor of `google-auth` #472, #529 (#637 by @BigHeadGeorge)
* Convert `oauth2client` credentials to `google-auth` (#711 by @aiguofer)
* Remove unnecessary `login()` from `gspread.authorize`
* Fix sheet name quoting issue (#554, #636, #716):
+ Add quotes to worksheet title for get_all_values (#640 by @grlbrwrg, #717 by @zynaxsoft)
+ Escaping title containing single quotes with double quotes (#730 by @vijay-shanker)
+ Use `utils.absolute_range_name()` to handle range names (#748)
* Fix `numericise()`: add underscores test to work in python2 and <python3.6 (#622 by @epicfaace)
* Add `supportsAllDrives` to Drive API requests (#709 by @justinr1234)
* Add `Worksheet.merge_cells()` (#713 by @lavigne958)
* Improve `Worksheet.merge_cells()` and add `merge_type` parameter (#742 by @aiguofer)
* Add `Worksheet.sort()` (#639 by @kirillgashkov)
* Add ability to reorder worksheets #570 (#571 by @robin900)
+ Add `Spreadsheet.reorder_worksheets()`
+ Add `Worksheet.update_index()`
* Add `test_update_cell_objects` (#698 by @ogroleg)
* Add `Worksheet.append_rows()` (#556 by @martinwarby, #694 by @fabytm)
* Add `Worksheet.delete_rows()` (#615 by @deverlex)
* Speed up `Client.open()` by querying files by title in Google Drive (#684 by @aiguofer)
* Add `freeze`, `set_basic_filter` and `clear_basic_filter` methods to `Worksheet` (#574 by @aiguofer)
* Use Drive API v3 for creating and deleting spreadsheets (#573 by @aiguofer)
* Implement `value_render_option` in `get_all_values` (#648 by @mklaber)
* Set position of a newly added worksheet (#688 by @djmgit)
* Add url properties for `Spreadsheet` and `Worksheet` (#725 by @CrossNox)
OBS-URL: https://build.opensuse.org/request/show/880012
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-gspread?expand=0&rev=7
* Add `Worksheet.insert_note()`, `Worksheet.update_note()`, `Worksheet.clear_note()` (#818 by @lavigne958)
* Add `Worksheet.insert_cols()` (#802 by @AlexeyDmitriev)
* Add `value_render_option` parameter to `Worksheet.get_all_records()` (#776 by @damgad)
* Remove `requests` from `install_requires` (#801)
* Simplify implementation of `Worksheet.insert_rows()` (#799 by @AlexeyDmitriev)
* Add `auth.service_account_from_dict()` (#785 b7 @mahenzon)
* Fix `ValueRange.from_json()` (#791 by @erakli)
* Allow `auth` to be `None`. Fix#773 (#774 by @lepture)
* Add `Worksheet.insert_rows()` (#734 by @tr-fi)
* Add `Worksheet.copy_to()` (#758 by @JoachimKoenigslieb)
* Add ability to create a cell instance using A1 notation (#765 by @tivaliy)
* Add `auth.service_account()` (#768)
* Add Authlib usage (#552 by @lepture)
* Simplified OAuth2 flow (#762)
* Fix `Worksheet.delete_rows()` index error (#760 by @rafa-guillermo)
* Deprecate `Worksheet.delete_row()` (#766)
* Scope `Worksheet.find()` to a specific row or a column (#739 by @alfonsocv12)
* Add `Worksheet.add_protected_range()` #447 (#720 by @KesterChan01)
* Add ability to fetch cell address in A1 notation (#763 by @tivaliy)
* Add `Worksheet.delete_columns()` (#761 by @rafa-guillermo)
* Ignore numericising specific columns in `get_all_records` (#701 by @benjamindhimes)
* Add option ``folder_id`` when creating a spreadsheet (#754 by @Abdellam1994)
* Add `insertDataOption` to `Worksheet.append_row()` and `Worksheet.append_rows()` (#719 by @lobatt)
* Fix `TypeError` when using gspread in google colab (#750)
* Remove `oauth2client` in favor of `google-auth` #472, #529 (#637 by @BigHeadGeorge)
* Convert `oauth2client` credentials to `google-auth` (#711 by @aiguofer)
* Remove unnecessary `login()` from `gspread.authorize`
* Fix sheet name quoting issue (#554, #636, #716):
+ Add quotes to worksheet title for get_all_values (#640 by @grlbrwrg, #717 by @zynaxsoft)
+ Escaping title containing single quotes with double quotes (#730 by @vijay-shanker)
+ Use `utils.absolute_range_name()` to handle range names (#748)
* Fix `numericise()`: add underscores test to work in python2 and <python3.6 (#622 by @epicfaace)
* Add `supportsAllDrives` to Drive API requests (#709 by @justinr1234)
* Add `Worksheet.merge_cells()` (#713 by @lavigne958)
* Improve `Worksheet.merge_cells()` and add `merge_type` parameter (#742 by @aiguofer)
* Add `Worksheet.sort()` (#639 by @kirillgashkov)
* Add ability to reorder worksheets #570 (#571 by @robin900)
+ Add `Spreadsheet.reorder_worksheets()`
+ Add `Worksheet.update_index()`
* Add `test_update_cell_objects` (#698 by @ogroleg)
* Add `Worksheet.append_rows()` (#556 by @martinwarby, #694 by @fabytm)
* Add `Worksheet.delete_rows()` (#615 by @deverlex)
* Speed up `Client.open()` by querying files by title in Google Drive (#684 by @aiguofer)
* Add `freeze`, `set_basic_filter` and `clear_basic_filter` methods to `Worksheet` (#574 by @aiguofer)
* Use Drive API v3 for creating and deleting spreadsheets (#573 by @aiguofer)
* Implement `value_render_option` in `get_all_values` (#648 by @mklaber)
* Set position of a newly added worksheet (#688 by @djmgit)
* Add url properties for `Spreadsheet` and `Worksheet` (#725 by @CrossNox)
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=13
- Update to 3.3.1
* Support old and new collections.abc.Sequence (#745 by @timgates42)
* Added `Spreadsheet.values_batch_update()` (#731)
* Added more parameters to `Worksheet.append_row()` (#726)
* Fix usage of client.openall when a title is passed in (#572 by @aiguofer)
* Fixed sharing from Team Drives (#646 by @wooddar)
* Fixed KeyError in list comprehension in `Spreadsheet.remove_permissions()` (#643 by @wooddar)
* Added `Spreadsheet.values_batch_get()` (#705 by @aiguofer)
* Added `stacklevel=2` to deprecation warnings
OBS-URL: https://build.opensuse.org/request/show/792477
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=11
- Update to 3.1.0:
* Dropped Python 2.6 support
* Fixed KeyError in urllib.quote in Python 2 (#605, #558)
* Fixed Worksheet.title being out of sync after using update_title (#542 by @ryanpineo)
* Fix parameter typos in docs (#616 by @bryanallen22)
* Miscellaneous docs fixes (#604 by @dgilman)
* Fixed typo in docs (#591 by @davidefiocco)
* Added a method to copy spreadsheets (#625 by @dsask)
* Added with_link attribute when sharing / adding permissions (#621 by @epicfaace)
* Added ability to duplicate a worksheet (#617)
* Change default behaviour of numericise function #499 (#502 by @danthelion)
* Added stacklevel=2 to deprecation warnings
- Switch to github tarball for tests
OBS-URL: https://build.opensuse.org/request/show/685353
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-gspread?expand=0&rev=4
* Dropped Python 2.6 support
* Fixed KeyError in urllib.quote in Python 2 (#605, #558)
* Fixed Worksheet.title being out of sync after using update_title (#542 by @ryanpineo)
* Fix parameter typos in docs (#616 by @bryanallen22)
* Miscellaneous docs fixes (#604 by @dgilman)
* Fixed typo in docs (#591 by @davidefiocco)
* Added a method to copy spreadsheets (#625 by @dsask)
* Added with_link attribute when sharing / adding permissions (#621 by @epicfaace)
* Added ability to duplicate a worksheet (#617)
* Change default behaviour of numericise function #499 (#502 by @danthelion)
* Added stacklevel=2 to deprecation warnings
- Switch to github tarball for tests
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=7
