- update to 6.1.4:
  * remove dependency on requests-2.27.0
  * ignore jinja CVE by @lavigne958 in
    https://github.com/burnash/gspread/pull/1481
  * Remove passing exception as args to super in APIError by
    @mike-flowers-airbnb in
    https://github.com/burnash/gspread/pull/1477
  * better handler API error parsing. by @lavigne958 in
    https://github.com/burnash/gspread/pull/1510
  * Add test on receiving an invalid JSON in the APIError
    exception handler. by @lavigne958 in
    https://github.com/burnash/gspread/pull/1512

• Files Changed
• Browse Source

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

• 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

- 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

- 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

- 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

• Files Changed
• Browse Source

• Files Changed
• Browse Source

• Files Changed
• Browse Source

• 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

• Files Changed
• Browse Source

• Files Changed
• Browse Source

- 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

• Files Changed
• Browse Source

- Remove superfluous devel dependency for noarch package

• Files Changed
• Browse Source

Automatic submission by obs-autosubmit

• Files Changed
• Browse Source

Google spreadsheet access in python

• Browse Source