baserev update by copy to link target

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- Update to version 5.7.2 
  * Fix: hidden property might not be set from the API by @lavigne958 in #1151

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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)

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source