Changelog History
Page 1
-
v5.5.0 Changes
August 31, 2022- ๐ Use pathlib by @lavigne958 in https://github.com/burnash/gspread/pull/1057
- Migrate to drive API V3 by @lavigne958 in https://github.com/burnash/gspread/pull/1060
- Implement eq method for
Cell
by @chisvi in https://github.com/burnash/gspread/pull/1063 - โ Add missing documentation on
set_timeout
by @lavigne958 in https://github.com/burnash/gspread/pull/1070 - โ Add method to transfer / accept ownership of a spreadsheet by @lavigne958 in https://github.com/burnash/gspread/pull/1068
- โ Add
client_factory
param toauth
methods by @jlumbroso in https://github.com/burnash/gspread/pull/1075 - Fix
list_protected_ranges
by @lavigne958 in https://github.com/burnash/gspread/pull/1076 - โ Add function to convert column letter to column index by @lavigne958 in https://github.com/burnash/gspread/pull/1077
- ๐ Fix docstring name of named_range() param by @dgilman in https://github.com/burnash/gspread/pull/1081
- ๐ Fix grammar in docstring for client.export by @dgilman in https://github.com/burnash/gspread/pull/1080
- ๐ Many typo fixes to worksheet docstrings by @dgilman in https://github.com/burnash/gspread/pull/1083
- ๐ Fix function
numericise_all
by @lavigne958 in https://github.com/burnash/gspread/pull/1082 - Fix documentation about
oauth_from_dict
by @lavigne958 in https://github.com/burnash/gspread/pull/1088 - inherit_from_before option for insert_row/insert_rows by @yongrenjie in https://github.com/burnash/gspread/pull/1092
- โ add method to change the color of a tab by @lavigne958 in https://github.com/burnash/gspread/pull/1095
- ๐ docs: Fix a few typos by @timgates42 in https://github.com/burnash/gspread/pull/1094
- ๐ Fix typo in
Worksheet.batch_format
method by @lavigne958 in https://github.com/burnash/gspread/pull/1101
๐ New Contributors
- @chisvi made their first contribution in https://github.com/burnash/gspread/pull/1063
- @jlumbroso made their first contribution in https://github.com/burnash/gspread/pull/1075
- @yongrenjie made their first contribution in https://github.com/burnash/gspread/pull/1092
-
v5.4.0 Changes
June 01, 2022- ๐ fix typo by @joswlv in https://github.com/burnash/gspread/pull/1031
- Fix error message in
get_all_records
by @lavigne958 in https://github.com/burnash/gspread/pull/1028 - โ Added feature request #1022. Auto resizing is now available for rows โฆ by @mketer1 in https://github.com/burnash/gspread/pull/1033
- โ add new method to hide/show a worksheet by @lavigne958 in https://github.com/burnash/gspread/pull/1030
- feat: Download PDF from Spreadsheet #1035 by @100paperkite in https://github.com/burnash/gspread/pull/1036
- Add test on
auto_resize_columns
by @lavigne958 in https://github.com/burnash/gspread/pull/1039 - โ Add method to unmerge cells by @lavigne958 in https://github.com/burnash/gspread/pull/1040
- โ Add method to delete a protected range by @lavigne958 in https://github.com/burnash/gspread/pull/1042
- ๐ Feature/clean organize documentation by @lavigne958 in https://github.com/burnash/gspread/pull/1043
- โ Add warning about deprecated oauth flow by @lavigne958 in https://github.com/burnash/gspread/pull/1047
- โ Add new
batch_format
method. by @lavigne958 in https://github.com/burnash/gspread/pull/1049 - Encode string to utf-8 when importing CSV content by @lavigne958 in https://github.com/burnash/gspread/pull/1054
๐ New Contributors
- @joswlv made their first contribution in https://github.com/burnash/gspread/pull/1031
- @mketer1 made their first contribution in https://github.com/burnash/gspread/pull/1033
- @100paperkite made their first contribution in https://github.com/burnash/gspread/pull/1036
-
v5.3.2 Changes
April 12, 2022- ๐ Bugfix/black python3.10 by @lavigne958 in https://github.com/burnash/gspread/pull/1020
- ๐ Automate releases by @lavigne958 in https://github.com/burnash/gspread/pull/1025
- ๐ Bugfix/get all record duplicated columns by @lavigne958 in https://github.com/burnash/gspread/pull/1021
-
v5.3.0 Changes
March 28, 2022- ๐ Feature/rework test cassettes recording by @lavigne958 in https://github.com/burnash/gspread/pull/1004
- โ add method list protected ranges by @lavigne958 in https://github.com/burnash/gspread/pull/1008
- โ Add new methods to add/list/delete dimensionGroups by @lavigne958 in https://github.com/burnash/gspread/pull/1010
- โ Add method to hide rows/columns by @lavigne958 in https://github.com/burnash/gspread/pull/1012
- โ Add ability to rename Spreadsheets (via a new Spreadsheet.update_title) by @jansim in https://github.com/burnash/gspread/pull/1013
๐ New Contributors
- @jansim made their first contribution in https://github.com/burnash/gspread/pull/1013
-
v5.2.0 Changes
February 27, 2022- Copy comments when during spreadsheet copy by @lavigne958 in https://github.com/burnash/gspread/pull/979
- โก๏ธ Update user-guide.rst by @maky-hnou in https://github.com/burnash/gspread/pull/980
- ๐ merge setup test cassettes by @lavigne958 in https://github.com/burnash/gspread/pull/982
- ๐ Feature/add header validation get all records by @lavigne958 in https://github.com/burnash/gspread/pull/984
- โ Add timeout to client by @lavigne958 in https://github.com/burnash/gspread/pull/987
- ๐ Feature/update timezone and locale by @lavigne958 in https://github.com/burnash/gspread/pull/989
- ๐ Feature/make case comparison in find by @lavigne958 in https://github.com/burnash/gspread/pull/990
- โก๏ธ Updated API rate limits by @hvinayan in https://github.com/burnash/gspread/pull/993
- ๐ Feature/prevent insert row to sheet with colon by @lavigne958 in https://github.com/burnash/gspread/pull/992
๐ New Contributors
- @maky-hnou made their first contribution in https://github.com/burnash/gspread/pull/980
- @hvinayan made their first contribution in https://github.com/burnash/gspread/pull/993
-
v5.1.1 Changes
December 22, 2021- ๐ Fix documentation about oauth (#975 by @lavigne958)
-
v5.1.0 Changes
December 22, 2021๐ Codespell skip docs build folder (#962 by @lavigne958)
โก๏ธ Update contributing guidelines (#964 by @lavigne958)
โ Add oauth from dict (#967 by @lavigne958)
โก๏ธ Update README.md to include badges (#970 by @lavigne958)
โ Add new method to get all values as a list of Cells (#968 by @lavigne958)
automatic conversion of a cell letter to uppercase (#972 by @Burovytskyi)
-
v5.0.0 Changes
November 26, 2021๐ 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
andtest.py
(#912 by @lavigne958)parent 39d1ecb59ca3149a8f46094c720efab883a0dc11 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 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)
-
v4.0.1 Changes
August 07, 2021- Do not overwrite original value when trying to convert to a number (#902 by @lavigne958)
-
v4.0.0 Changes
August 01, 2021๐ Changed
Worksheet.find()
method returnsNone
if nothing is found (#899 by @GastonBC)โ Add
Worksheet.batch_clear()
to clear multiple ranges. (#897 by @lavigne958)๐ Fix
copy_permission
argument comparison inClient.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()
whenauthorized_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
andlastUpdate
time fromSpreadSheet
on open (#872 by @lavigne958)Fix bug with
Worksheet.insert_row()
withvalue_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 toClient.copy()
(#851 by @punnerud)๐ Fix typos in docstrings (#848 by @dgilman)