Revisions of python-gspread
buildservice-autocommit
accepted
request 1167621
from
Dirk Mueller (dirkmueller)
(revision 30)
baserev update by copy to link target
Dirk Mueller (dirkmueller)
committed
(revision 29)
- 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
buildservice-autocommit
accepted
request 1145003
from
Dirk Mueller (dirkmueller)
(revision 28)
baserev update by copy to link target
Dirk Mueller (dirkmueller)
committed
(revision 27)
- 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
buildservice-autocommit
accepted
request 1142772
from
Dirk Mueller (dirkmueller)
(revision 26)
baserev update by copy to link target
Dirk Mueller (dirkmueller)
committed
(revision 25)
- 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
buildservice-autocommit
accepted
request 1138508
from
Dirk Mueller (dirkmueller)
(revision 24)
baserev update by copy to link target
Dirk Mueller (dirkmueller)
committed
(revision 23)
- 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
buildservice-autocommit
accepted
request 1041206
from
Dirk Mueller (dirkmueller)
(revision 22)
baserev update by copy to link target
Dirk Mueller (dirkmueller)
accepted
request 1041200
from
Yogalakshmi Arunachalam (yarunachalam)
(revision 21)
- Update to version 5.7.2 * Fix: hidden property might not be set from the API by @lavigne958 in #1151
buildservice-autocommit
accepted
request 1039913
from
Dirk Mueller (dirkmueller)
(revision 20)
baserev update by copy to link target
Dirk Mueller (dirkmueller)
accepted
request 1039850
from
Yogalakshmi Arunachalam (yarunachalam)
(revision 19)
- 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
buildservice-autocommit
accepted
request 1032321
from
Matej Cepl (mcepl)
(revision 18)
baserev update by copy to link target
Matej Cepl (mcepl)
accepted
request 1032005
from
Yogalakshmi Arunachalam (yarunachalam)
(revision 17)
- Update to version 5.6.2 (2022-10-23) * update parent folder for client.copy method by @lavigne958 in #1123 - Update to version 5.6.0 (2022-09-10) * 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
buildservice-autocommit
accepted
request 1006889
from
Markéta Machová (mcalabkova)
(revision 16)
baserev update by copy to link target
Markéta Machová (mcalabkova)
accepted
request 1006789
from
Yogalakshmi Arunachalam (yarunachalam)
(revision 15)
- 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
buildservice-autocommit
accepted
request 880012
from
Steve Kowalik (StevenK)
(revision 14)
baserev update by copy to link target
Steve Kowalik (StevenK)
committed
(revision 13)
- 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)
buildservice-autocommit
accepted
request 792491
from
Tomáš Chvátal (scarabeus_iv)
(revision 12)
baserev update by copy to link target
Tomáš Chvátal (scarabeus_iv)
accepted
request 792477
from
Markéta Machová (mcalabkova)
(revision 11)
- 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
Displaying revisions 1 - 20 of 30