All Versions
49
Latest Version
Avg Release Cycle
70 days
Latest Release
1097 days ago

Changelog History
Page 2

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

  • v3.1.0 Changes

    November 27, 2018

    ⬇️ 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