Gspread

------------------
* 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 <cclaussme.com> 1621149013 +0200 commit
ter Christian Clauss <cclaussme.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_id`` when creating a spreadsheet (754 by Abdellam1994)

* Add `insertDataOption` to `Worksheet.append_row()` and `Worksheet.append_rows()` (719 by lobatt)