All Versions
40
Latest Version
Avg Release Cycle
81 days
Latest Release
86 days ago

Changelog History
Page 1

  • v4.0.0 Changes

    August 01, 2021
    • ๐Ÿ”„ 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)

  • v3.7.0 Changes

    February 18, 2021
    • โšก๏ธ 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 Changes

    April 30, 2020

    โž• 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 Changes

    April 23, 2020

    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 Changes

    April 06, 2020
    • ๐Ÿ›  Fix Python 2 SyntaxError in models.py #751 (#752)
  • v3.4.1 Changes

    April 05, 2020
    • ๐Ÿ›  Fix TypeError when using gspread in google colab (#750)
  • v3.4.0 Changes

    April 05, 2020

    โœ‚ 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):

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

    April 01, 2020
    • ๐Ÿ‘Œ Support old and new collections.abc.Sequence in utils (#745 by @timgates42)
  • v3.3.0 Changes

    March 12, 2020

    Added Spreadsheet.values_batch_update() (#731)

    โž• Added:

    • Worksheet.get()
    • Worksheet.batch_get()
    • Worksheet.update()
    • Worksheet.batch_update()

    - Worksheet.format()

    โž• Added more parameters to Worksheet.append_row() (#726)

    ๐Ÿ›  Fix usage of client.openall when a title is passed in (#572 by @aiguofer)

  • v3.2.0 Changes

    January 30, 2020

    Fixed gspread.utils.cell_list_to_rect() on non-rect cell list (#613 by @skaparis)

    ๐Ÿ›  Fixed sharing from Team Drives (#646 by @wooddar)

    ๐Ÿ›  Fixed KeyError in list comprehension in Spreadsheet.remove_permissions() (#643 by @wooddar)

    ๐Ÿ›  Fixed typos in docstrings and a docstring type param (#690 by @pedrovhb)

    ๐Ÿ‘ Clarified supported Python versions (#651 by @hugovk)

    ๐Ÿ›  Fixed the Exception message in APIError class (#634 by @lordofinsomnia)

    Fixed IndexError in Worksheet.get_all_records() (#633 by @AivanF)

    Added Spreadsheet.values_batch_get() (#705 by @aiguofer)