v5.0.0

5.0.0 (2021-11-26)

• 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 39d1ecb author Christian Clauss [email protected] 1621149013 +0200 commit
  ter Christian Clauss [email protected] 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 formating (#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)

v4.0.1

• Do not overwrite original value when trying to convert to a number (#902 by @lavigne958)

v4.0.0

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

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

v3.7.0

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

v3.6.0

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

v3.5.0

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

v3.4.2

• Fix Python 2 SyntaxError in models.py #751 (#752)

v3.4.1

• Fix TypeError when using gspread in google colab (#750)

v3.4.0

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

• Add Python 3.8 to Travis CI (#738 by @artemrys)

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

• Update docs: "APIs & auth" menu deprecation, remove outdated images in oauth2.rst (#706 by @manasouza)

v3.3.1

• Support old and new collections.abc.Sequence in utils (#745 by @timgates42)