- add note about runnings tests to contrib guide by @alifeee in #1465
- Some updates on get_notes by @nbwzx in #1461
- Add some missing typing in code by @lavigne958 in #1448
- More fixes for Worksheet.update argument ordering & single cell updating (i.e. now Worksheet.update_acell) by @alexmalins in #1449
- Added 'add_data_validation` to Workhsheet [Issue #1420] by @muddi900 in #1444
- Bump typing-extensions from 4.10.0 to 4.11.0 by @dependabot in #1450
- Bump black from 23.3.0 to 24.4.0 by @dependabot in #1452
- Fix incorrect version number in HISTORY.rst from 6.0.1 to 6.1.0 by @yhay81 in #1455
- add get_notes by @nbwzx in #1451
- Bump mypy from 1.9.0 to 1.10.0 by @dependabot in #1459
- Bump black from 24.4.0 to 24.4.2 by @dependabot in #1460
- bugfix: handle domain name in spreadsheet copy permissions by @lavigne958 in #1458
- Fix/api key auth version by @alifeee in #1463
- Ignore pip vulnerabilities in CI. by @lavigne958 in #1464
- Remove StrEnum dependency and added custom class[issue #1462] by @muddi900 in #1469
- Add py.typed marker by @lavigne958 in #1422
- Improve back-off client by @lavigne958 in #1415
- Add new auth method API key by @lavigne958 in #1428
- Bugfix/add set timeout by @lavigne958 in #1417
- Fix wrapper cast_to_a1_notation by @lavigne958 in #1427
- Bump bandit from 1.7.5 to 1.7.8 by @dependabot in #1433
- Bump mypy from 1.6.1 to 1.9.0 by @dependabot in #1432
- Bump typing-extensions from 4.8.0 to 4.10.0 by @dependabot in #1424
- Bump flake8 from 5.0.4 to 7.0.0 by @dependabot in #1375
- fix error message readability by @imrehg in #1435
- Add missing method import_csv() by @lavigne958 in #1426
- update readme examples by @alifeee in #1431
- Add user friendly message when we can't override a test cassette by @lavigne958 in #1438
- Allow "warning" type protected ranges by @alifeee in #1439
- Improve README and documentation with value render options by @lavigne958 in #1446
- Fixup gspread client init arguments by @lavigne958 in #1412
- Allow client to use external Session object by @lavigne958 in #1384
- Remove-py-3.7-support by @alifeee in #1396
- bugfix/client export by @lavigne958 in #1392
- Fix oauth flow typo by @alifeee in #1397
- check oauth creds type using isinstance by @alifeee in #1398
- Fix type hints at find method in worksheet.py by @deftfitf in #1407
- Fixup get empty cell value is None by @lavigne958 in #1404
- Fix missing attribute spreadsheet in Worksheet. by @lavigne958 in #1402
- update migration guide by @alifeee in #1409
- Remove deprecated method delete_row by @cgkoutzigiannis in #1062
- Initial typing in client.py by @OskarBrzeski in #1159
- Split client http client by @lavigne958 in #1190
- Spelling fix & update docs with date_time_render_option behaviour by @alifeee in #1187
- #966 Add sketch typing for utils.py by @butvinm in #1196
- Remove accepted_kwargs decorator by @lavigne958 in #1229
- Remove/python-3.7 by @alifeee in #1234
- Bump isort from 5.11.4 to 5.12.0 by @dependabot in #1165
- bump flake8 to 6.0.0 by @alifeee in #1236
- merge master into 6.0.0 by @lavigne958 in #1241
- Remplace named tuples with enums by @lavigne958 in #1250
- Feature/add type hints worksheets by @lavigne958 in #1254
- Implement hex color conversion by @idonec in #1270
- remove lastUpdateTime by @alifeee in #1295
- Merge master into feature/release_6_0_0 by @alifeee in #1320
- Add type checking to lint by @alifeee in #1337
- Warning/update swapped args by @alifeee in #1336
- Improve Worksheet.sort() signature by @lavigne958 in #1342
- Make get_values and alias of get by @alifeee in #1296
- fix type issue (remove .first() function) by @alifeee in #1344
- Remove/get records use index by @alifeee in #1345
- increase warning stacklevel from 1 to 2 by @alifeee in #1361
- Feature/merge master by @lavigne958 in #1371
- feature/merge master by @lavigne958 in #1372
- Simplify get records by @alifeee in #1374
- Add util function to_records to build records by @lavigne958 in #1377
- feature/add utils get records by @lavigne958 in #1378
- Add migration guide for get_all_records by @lavigne958 in #1379
- feature/merge master into release 6 0 0 by @lavigne958 in #1381
- Feature/release 6 0 0 by @lavigne958 in #1382
- Bump actions/setup-python from 4 to 5 by @dependabot in #1370
- Fixed default value of merge_type parameter in merge_cells function docstring. by @neolooong in #1373
- 1363 get all records retrieves a large number of empty rows after the end of the data by @alifeee in #1364
- Many fixes for get_records by @alifeee in #1357
- change worksheet.update migration guide by @alifeee in #1362
- feature/readme migration v6 by @lavigne958 in #1297
- add deprecation warnings for lastUpdateTime... by @alifeee in #1333
- remove use_index and references to it in get_records by @alifeee in #1343
- make deprecation warning dependent on if kwarg is used for client_factory by @alifeee in #1349
- fix 1352 expected headers broken by @alifeee in #1353
- fix combine_merged_cells when using from a range that doesn't start at A1 by @alifeee in #1335
- feature -- adding worksheet.get_records to get specific row ranges by @AndrewBasem1 in #1301
- Fix list_spreadsheet_files return value by @mephinet in #1308
- Fix warning message for worksheet.update method by @ksj20 in #1312
- change lambda function to dict (fix pyupgrade issue) by @alifeee in #1319
- allows users to silence deprecation warnings by @lavigne958 in #1324
- Add maintain_size to keep asked for size in get, get_values by @alifeee in #1305
- Fix list_spreadsheet_files return value by @mephinet in #1308
- Fix merge_combined_cells in get_values (AND 5.11.2 RELEASE) by @alifeee in #1299
- Bump actions/checkout from 3 to 4 by @dependabot in #1288
- remove Drive API access on Spreadsheet init (FIX - VERSION 5.11.1) by @alifeee in #1291
- add docs/build to .gitignore by @alifeee in #1246
- add release process to CONTRIBUTING.md by @alifeee in #1247
- Update/clean readme badges by @lavigne958 in #1251
- add test_fill_gaps and docstring for fill_gaps by @alifeee in #1256
- Remove API calls from creationTime/lastUpdateTime by @alifeee in #1255
- Fix Worksheet ID Type Inconsistencies by @FlantasticDan in #1269
- Add column_count prop as well as col_count by @alifeee in #1274
- Add required kwargs with no default value by @lavigne958 in #1271
- Add deprecation warnings for colors by @alifeee in #1278
- Add better Exceptions on opening spreadsheets by @alifeee in #1277
- Fix rows_auto_resize in worksheet.py by removing redundant self by @MagicMc23 in #1194
- Add deprecation warning for future release 6.0.x by @lavigne958 in #1195
- FEATURE: show/hide gridlines (#1197) by @alifeee in #1202
- CLEANUP: cleanup tox.ini, and ignore ./env by @alifeee in #1200
- Refactor/update-contributing-guide by @alifeee in #1206
- Spelling fix (with legacy option) by @alifeee in #1210
- 457-fetch-without-hidden-worksheets by @alifeee in #1207
- Add_deprecated_warning_sort_method by @lavigne958 in #1198
- Update (and test for) internal properties on change by @alifeee in #1211
- Feature: Add "Remove tab colour" method by @alifeee in #1199
- Refresh-test-cassettes by @alifeee in #1217
- update self._properties after batch_update by @alifeee in #1221
- 700-fill-merged-cells by @alifeee in #1215
- Fix/update-internal-properties by @alifeee in #1225
- Add breaking change warning in Worksheet.update() by @lavigne958 in #1226
- Bump codespell from 2.2.4 to 2.2.5 by @dependabot in #1232
- Add/refresh last update time by @alifeee in #1233
- Update-build-tools by @alifeee in #1231
- add read the doc configuration file by @lavigne958 in #1235
- update licence year by @alifeee in #1237
- remove deprecated methods from tests by @alifeee in #1238
- Bugfix/fix get last update time by @lavigne958 in #1186
- Add batch notes insert/update/clear by @lavigne958 in #1189
- Bump black from 22.10.0 to 22.12.0 by @dependabot in #1154
- Bump isort from 5.10.1 to 5.11.3 by @dependabot in #1155
- Bump isort from 5.11.3 to 5.11.4 by @dependabot in #1157
- #1104: added a delete by worksheet id method by @muddi900 in #1148
- improve CI workflow - upgrade setuptools to fix CVE by @lavigne958 in #1179
- Bump codespell from 2.2.2 to 2.2.4 by @dependabot in #1178
- Bump bandit from 1.7.4 to 1.7.5 by @dependabot in #1177
- Bump black from 22.12.0 to 23.1.0 by @dependabot in #1168
- Update user-guide.rst to include a warning by @alsaenko in #1181
- Fixed typo in docs/user-guide.rst by @raboba2re in #1182
- Bump black from 23.1.0 to 23.3.0 by @dependabot in #1183
- Handle cases when rgbColor is not set by @lavigne958 in #1184
- Fix: hidden property might not be set from the API by @lavigne958 in #1151
- Fix dependencies required version by @lavigne958 in #1147
- 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
- update parent folder for client.copy method by @lavigne958 in #1123
- Fix clear_note method when using numeric boundaries by @lavigne958 in #1106
- Fix a typo in the permissions:create API payload by @jiananma in #1107
- Fix spreadsheet URL by @lavigne958 in #1110
- Return created permission on Spreadsheet.share() by @lavigne958 in #1111
- (fixed #1113) Supply correct Google API v3 permission for domains by @NickCrews in #1115
- Bugfix/numericese all by @lavigne958 in #1119
- 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
- @chisvi made their first contribution in #1063
- @jlumbroso made their first contribution in #1075
- @yongrenjie made their first contribution in #1092
- 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
- Add new batch_format method. by @lavigne958 in #1049
- Encode string to utf-8 when importing CSV content by @lavigne958 in #1054
- @joswlv made their first contribution in #1031
- @mketer1 made their first contribution in #1033
- @100paperkite made their first contribution in #1036
- Bugfix/black python3.10 by @lavigne958 in #1020
- Automate releases by @lavigne958 in #1025
- Bugfix/get all record duplicated columns by @lavigne958 in #1021
- Feature/rework test cassettes recording by @lavigne958 in #1004
- add method list protected ranges by @lavigne958 in #1008
- Add new methods to add/list/delete dimensionGroups by @lavigne958 in #1010
- Add method to hide rows/columns by @lavigne958 in #1012
- Add ability to rename Spreadsheets (via a new Spreadsheet.update_title) by @jansim in #1013
## New Contributors * @jansim made their first contribution in #1013
- Copy comments when during spreadsheet copy by @lavigne958 in #979
- Update user-guide.rst by @maky-hnou in #980
- merge setup test cassettes by @lavigne958 in #982
- Feature/add header validation get all records by @lavigne958 in #984
- Add timeout to client by @lavigne958 in #987
- Feature/update timezone and locale by @lavigne958 in #989
- Feature/make case comparison in find by @lavigne958 in #990
- Updated API rate limits by @hvinayan in #993
- Feature/prevent insert row to sheet with colon by @lavigne958 in #992
## New Contributors * @maky-hnou made their first contribution in #980 * @hvinayan made their first contribution in #993
- Fix documentation about oauth (#975 by @lavigne958)
- Codespell skip docs build folder (#962 by @lavigne958)
- Update contributing guidelines (#964 by @lavigne958)
- Add oauth from dict (#967 by @lavigne958)
- Update README.md to include badges (#970 by @lavigne958)
- Add new method to get all values as a list of Cells (#968 by @lavigne958)
- automatic conversion of a cell letter to uppercase (#972 by @Burovytskyi)
- Fix a typo in HISTORY.rst (#904 by @TurnrDev)
- Fix typo and fix return value written in docstrings (#903 by @rariyama)
- Add deprecation warning for delete_row method in documentation (#909 by @javad94)
- split files models.py and test.py (#912 by @lavigne958)
* parent 39d1ecb59ca3149a8f46094c720efab883a0dc11 author Christian Clauss <cclauss@me.com> 1621149013 +0200 commit ter Christian Clauss <cclauss@me.com> 1630103641 +0200 (#869 by @cclaus)
- Enable code linter in CI (#915 by @lavigne958)
- isort your imports (again), so you don't have to (#914 by @cclaus)
- lint_python.yml: Try 'tox -e py' to test current Python (#916 by @cclaus)
- Add more flake8 tests (#917 by @cclaus)
- Update test suite (#918 by @cclaus)
- Avoid IndexError when row_values() returns an empty row (#920 by @cclaus)
- Bugfix - remove wrong argument in batch_update docstring (#912 by @lavigne958)
- Improvement - Add Worksheet.index property (#922 by @lavigne958)
- Add ability to create directory if it does not exist before saving the credentials to disk. (#925 by @benhoman)
- Update test framework and VCR and cassettes (#926 by @lavigne958)
- Delete .travis.yml (#928 by @cclaus)
- Update tox.ini with all linting commands under lint env (by @lavigne958)
- Build package and docs in CI (#930 by @lavigne958)
- Update oauth2.rst (#933 by @amlestin)
- Update the link to the Google Developers Console (#934 by @Croebh)
- allow tests to run on windows, add and improve tests in WorksheetTests, add test on unbounded range, use canonical range as specified in the API, add test cassettes, prevent InvalidGridRange, improve code formatting (#937 by @Fendse)
- fix fully qualified class names in API documentation (#944 by @geoffbeier)
- fix editor_users_emails - get only from list not all users added to spreadsheet (#939 by @Lukasz)
- add shadow method to get a named range from a speadsheet instance (#941 by @lavigne958)
- auto_resize_columns (#948 by @FelipeSantos75)
- add functions for defining, deleting and listing named ranges (#945 by @p-doyle)
- Implement open sheet within Drive folder (#951 by @datavaluepeople)
- Fix get range for unbounded ranges (#954 by @lavigne958)
- remove potential I/O when reading spreadsheet title (956 by @lavigne958)
- Add include_values_in_response to append_row & append_rows (#957 by @martimarkov)
- replace raw string "ROWS" & "COLUMNS" to Dimension named tuple, replace raw string "FORMATTED_VALUE", "UNFORMATTED_VALUE", "FORMULA" to ValueRenderOption named tuple, replace raw string "RAW", "USER_ENTERED" to ValueInputOption named tuple (#958 by @ccppoo)
- Do not overwrite original value when trying to convert to a number (#902 by @lavigne958)
- Changed Worksheet.find() method returns None if nothing is found (#899 by @GastonBC)
- Add Worksheet.batch_clear() to clear multiple ranges. (#897 by @lavigne958)
- Fix copy_permission argument comparison in Client.copy() method (#898 by @lavigne958)
- Allow creation of spreadhsheets in a shared drive (#895 by @lavigne958)
- Allow gspread.oauth() to accept a custom credential file (#891 by @slmtpz)
- Update tox.ini, remove python2 from env list (#887 by @cclaus)
- Add SpreadSheet.get_worksheet_by_id() method (#857 by @a-crovetto)
- Fix store_credentials() when authorized_user_filename is passed (#884 by @neuenmuller)
- Remove python2 (#879 by @lavigne958)
- Use Makefile to run tests (#883 by @lavigne958)
- Update documentation Authentication:For End Users using OAuth Client ID (#835 by @ManuNaEira)
- Allow fetching named ranges from Worksheet.range() (#809 by @agatti)
- Update README to only mention python3.3+ (#877 by @lavigne958)
- Fetch creation and lastUpdate time from SpreadSheet on open (#872 by @lavigne958)
- Fix bug with Worksheet.insert_row() with value_input_option argument (#873 by @elijabesu)
- Fix typos in doc and comments (#868 by @cclauss)
- Auto cast numeric values from sheet cells to python int or float (#866 by @lavigne958)
- Add Worksheet.get_values() method (#775 by @burnash)
- Allow gspread.oauth() to accept a custom filename (#847 by @bastienboutonnet)
- Document dictionary credentials auth (#860 by @dmytrostriletskyi)
- Add Worksheet.get_note() (#855 by @water-ghosts )
- Add steps for creating new keys (#856 by @hanzala-sohrab)
- Add folder_id argument to Client.copy() (#851 by @punnerud)
- Fix typos in docstrings (#848 by @dgilman)
- Add Worksheet.insert_note(), Worksheet.update_note(), Worksheet.clear_note() (#818 by @lavigne958)
- Update documentation: oauth2.rst (#836 by @Prometheus3375)
- Documentation fixes (#838 by @jayeshmanani)
- Documentation fixes (#845 by @creednaylor)
- Add Worksheet.insert_cols() (#802 by @AlexeyDmitriev)
- Documentation fixes (#814 by @hkuffel)
- Update README.md (#811 by @tasawar-hussain)
- 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)
- Update documentation: oauth2.rst (#794 by @elnjensen)
- Update documentation: oauth2.rst (#789 by @Takur0)
- 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_idwhen creating a spreadsheet (#754 by @Abdellam1994) - Add insertDataOption to Worksheet.append_row() and Worksheet.append_rows() (#719 by @lobatt)
- Fix Python 2 SyntaxError in models.py #751 (#752)
- 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)
- Add Python 3.8 to Travis CI (#738 by @artemrys)
- 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)
- Update docs: "APIs & auth" menu deprecation, remove outdated images in oauth2.rst (#706 by @manasouza)
- Support old and new collections.abc.Sequence in utils (#745 by @timgates42)
- Added Spreadsheet.values_batch_update() (#731)
- Added:
- Worksheet.get()
- Worksheet.batch_get()
- Worksheet.update()
- Worksheet.batch_update()
- Worksheet.format()
- Added more parameters to Worksheet.append_row() (#719 by @lobatt, #726)
- Fix usage of client.openall when a title is passed in (#572 by @aiguofer)
- Fixed gspread.utils.cell_list_to_rect() on non-rect cell list (#613 by @skaparis)
- Fixed sharing from Team Drives (#646 by @wooddar)
- Fixed KeyError in list comprehension in Spreadsheet.remove_permissions() (#643 by @wooddar)
- Fixed typos in docstrings and a docstring type param (#690 by @pedrovhb)
- Clarified supported Python versions (#651 by @hugovk)
- Fixed the Exception message in APIError class (#634 by @lordofinsomnia)
- Fixed IndexError in Worksheet.get_all_records() (#633 by @AivanF)
- Added Spreadsheet.values_batch_get() (#705 by @aiguofer)
- 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
- Fixed #538 (#553 by @ADraginda)
- This version drops Google Sheets API v3 support.
- API v4 was the default backend since version 2.0.0.
- All v4-related code has been moved from gspread.v4 module to gspread module.
- Fixed #533 (#534 by @reallistic)
- URL encode the range in the value* functions (#530 by @aiguofer)
- Open team drive sheets by name (#527 by @ryantuck)
- Fixed #518
- Include v4 in setup.py
- Fetch all spreadsheets in Spreadsheet.list_spreadsheet_files (#522 by @aiguofer)
Ported the library to Google Sheets API v4.
This is a transition release. The v3-related code is untouched, but v4 is used by default. It is encouraged to move to v4 since the API is faster and has more features.
API v4 is a significant change from v3. Some methods are not backward compatible, so there's no support for this compatibility in gspread either.
These methods and properties are not supported in v4:
- Spreadsheet.updated
- Worksheet.updated
- Worksheet.export()
- Cell.input_value
- Remove deprecated HTTPError
- Fixed error when inserting permissions #431
- Added spreadsheet sharing functionality
- Added csv import
- Fixed bug where list of sheets isn't cleared on refetch #429, #386
- Fixed a missing return value in utils.a1_to_rowcol
- Fixed url parsing in Client.open_by_url
- Added updated property to Spreadsheet objects
- Added method to create blank spreadsheets #253
- Added method to clear worksheets #156
- Added method to delete a row in a worksheet #337
- Changed Worksheet.range method to accept integers as coordinates #142
- Added default_blank parameter to Worksheet.get_all_records #423
- Use xml.etree.cElementTree when available to reduce memory usage #348
- Fixed losing input_value data from following cells in Worksheet.insert_row #338
- Deprecated Worksheet.get_int_addr and Worksheet.get_addr_int in favour of utils.a1_to_rowcol and utils.rowcol_to_a1 respectively
- Fix exception format to support Python 2.6
- Use request session's connection pool in HTTPSession
- Removed deprecated ClientLogin
- Use Python requests instead of the native HTTPConnection object
- Optimized row_values and col_values
Optimized row_values and col_values Removed the _fetch_cells call for each method. This eliminates the adverse effect on runtime for large worksheets.
Fixes #285, #190, #179, and #113
Optimized row_values and col_values Removed the _fetch_cells call for each method. This eliminates the adverse effect on runtime for large worksheets.
Fixes #285, #190, #179, and #113
- Altered insert_row semantics to utilize range This avoids issuing one API request per cell to retrieve the Cell objects after the insertion row. This provides a significant speed-up for insertions at the beginning of large sheets.
- Added mock tests for Travis (MockSpreadsheetTest)
- Fixed XML header issue with Python 3
- Fixed Worksheet.export function and associated test
- Added spreadsheet feed helper
- Add CellNotFound to module exports Fixes #88
- Fixed utf8 encoding error caused by duplicate XML declarations
- Fixed AttributeError when URLError caught by HTTPError catch block Fixes #257
- Added __iter__ method to Spreadsheet class
- Fixed export test
- Switched tests to oauth
- Deprecation warning for ClientLogin #210
- Redirect github pages to ReadTheDocs
- Bugfixes
- Output error response #219 #170 #194.
- Added instructions on how to get oAuth credentials to docs.
- Fixed issue with Spreadsheet.del_worksheet.
- Automatically refresh OAuth2 token when it has expired.
- Added an insert_row method to Worksheet.
- Moved docs to Read The Docs.
- Added the numeric_value attribute to Cell.
- Added title property to Spreadsheet.
- Support for exporting worksheets.
- Added row selection for keys in Worksheet.get_all_records.
- Fixed version not available for read-only spreadsheets bug
- Added OAuth2 support
- Fixed regression bug #130. Not every POST needs If-Match header
- New Google Sheets support.
- Fixed get_all_values() on empty worksheet.
- Bugfix in get_int_addr().
- Changed the HTTP connectivity from urllib to httlib for persistent http connections.
- Support for deleting worksheets from a spreadsheet.
0.0.15 (2013-02-01) ------------------
- Couple of bugfixes.
0.0.14 (2013-01-31) ------------------
- Bugfix in Python 3.
0.0.12 (2011-12-25) ------------------
- Python 3 support.
- Enter the Docs.
- New skinnier login method.
- Pypi install bugfix.
- Batch cells update.
New spreadsheet open methods:
- Client.open_by_key
- Client.open_by_url
- Got rid of the wrapper.
- Support for pluggable http session object.
- Hacked a wrapper around Google's Python client library.