4a1b9192a1
- 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
Dirk Mueller2025-09-29 10:46:52 +00:00
ac2358ba3b
Accepting request 1178157 from devel:languages:python
Ana Guerrero2024-06-03 15:43:55 +00:00
ef944416f1
- 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]
Dirk Mueller2024-06-02 13:40:02 +00:00
11fe38be72
Accepting request 1167621 from devel:languages:python
Ana Guerrero2024-04-14 09:56:31 +00:00
b8acdc222f
- 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
Dirk Mueller2024-04-14 07:37:00 +00:00
9613dce179
Accepting request 1145003 from devel:languages:python
Ana Guerrero2024-02-08 18:02:18 +00:00
0c7ac98ded
- update to 6.0.1: * 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
Dirk Mueller2024-02-07 20:12:51 +00:00
4d88127210
Accepting request 1142772 from devel:languages:python
Ana Guerrero2024-01-30 17:26:50 +00:00
4abd576f23
- 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
Dirk Mueller2024-01-30 12:15:55 +00:00
b024ba1db0
Accepting request 1138508 from devel:languages:python
Ana Guerrero2024-01-15 21:15:57 +00:00
3f0f2deef5
- 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
Dirk Mueller2024-01-13 21:08:30 +00:00
080bfa5855
Accepting request 1032005 from home:yarunachalam:branches:devel:languages:python
Matej Cepl2022-10-30 16:20:35 +00:00
f1a6bb7a1a
Accepting request 1006889 from devel:languages:python
Richard Brown2022-09-29 16:14:04 +00:00
4b4b4c6a96
Accepting request 1006789 from home:yarunachalam:branches:devel:languages:python
Markéta Machová2022-09-29 09:28:08 +00:00
ee0fd8d85c
Accepting request 880012 from devel:languages:python
Richard Brown
2021-03-19 15:43:23 +00:00
8d21a2bb6f
- 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)
Steve Kowalik2021-03-19 05:27:28 +00:00
001583cb7a
- 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
Tomáš Chvátal
2019-03-15 12:51:45 +00:00
Ana Guerrero
Dirk Mueller
Dominique Leuenberger
Matej Cepl
Richard Brown
Markéta Machová
Richard Brown
Steve Kowalik
Tomáš Chvátal
Todd R