Gspread Versions Save

Google Sheets Python API

v6.1.0

1 month ago

Major changes

types can be obtained using mypy to type code using gspread
Add a new method to authenticate using API key for public spreadsheets

What's Changed

Add py.typed marker by @lavigne958 in https://github.com/burnash/gspread/pull/1422
Improve back-off client by @lavigne958 in https://github.com/burnash/gspread/pull/1415
Add new auth method API key by @lavigne958 in https://github.com/burnash/gspread/pull/1428
Bugfix/add set timeout by @lavigne958 in https://github.com/burnash/gspread/pull/1417
Fix wrapper cast_to_a1_notation by @lavigne958 in https://github.com/burnash/gspread/pull/1427
Bump bandit from 1.7.5 to 1.7.8 by @dependabot in https://github.com/burnash/gspread/pull/1433
Bump mypy from 1.6.1 to 1.9.0 by @dependabot in https://github.com/burnash/gspread/pull/1432
Bump typing-extensions from 4.8.0 to 4.10.0 by @dependabot in https://github.com/burnash/gspread/pull/1424
Bump flake8 from 5.0.4 to 7.0.0 by @dependabot in https://github.com/burnash/gspread/pull/1375
fix error message readability by @imrehg in https://github.com/burnash/gspread/pull/1435
Add missing method import_csv() by @lavigne958 in https://github.com/burnash/gspread/pull/1426
update readme examples by @alifeee in https://github.com/burnash/gspread/pull/1431
Add user friendly message when we can't override a test cassette by @lavigne958 in https://github.com/burnash/gspread/pull/1438
Allow "warning" type protected ranges by @alifeee in https://github.com/burnash/gspread/pull/1439
Improce README and documentation with value render options by @lavigne958 in https://github.com/burnash/gspread/pull/1446

New Contributors

@imrehg made their first contribution in https://github.com/burnash/gspread/pull/1435

Full Changelog: https://github.com/burnash/gspread/compare/v6.0.2...v6.1.0

v6.0.2

2 months ago

What's Changed

Fixup gspread client init arguments by @lavigne958 in https://github.com/burnash/gspread/pull/1412

Full Changelog: https://github.com/burnash/gspread/compare/v6.0.1...v6.0.2

v6.0.1

3 months ago

What's Changed

Allow client to use external Session object by @lavigne958 in https://github.com/burnash/gspread/pull/1384
Remove-py-3.7-support by @alifeee in https://github.com/burnash/gspread/pull/1396
bugfix/client export by @lavigne958 in https://github.com/burnash/gspread/pull/1392
Fix oauth flow typo by @alifeee in https://github.com/burnash/gspread/pull/1397
check oauth creds type using isinstance by @alifeee in https://github.com/burnash/gspread/pull/1398
Fix type hints at find method in worksheet.py by @deftfitf in https://github.com/burnash/gspread/pull/1407
Fixup get empty cell value is None by @lavigne958 in https://github.com/burnash/gspread/pull/1404
Fix missing attribute spreadsheet in Worksheet. by @lavigne958 in https://github.com/burnash/gspread/pull/1402
update migration guide by @alifeee in https://github.com/burnash/gspread/pull/1409

New Contributors

@deftfitf made their first contribution in https://github.com/burnash/gspread/pull/1407

Full Changelog: https://github.com/burnash/gspread/compare/v6.0.0...v6.0.1

v6.0.0

3 months ago

Main changes

The main changes in version 6 are:

gspread now has typing! This should make it easier to code with Python's typing autocomplete.
the client object has been changed so now you can implement your own

v5.12 to v6.0 Migration Guide

Please see migration guide

What's Changed

Remove deprecated method delete_row by @cgkoutzigiannis in https://github.com/burnash/gspread/pull/1062
Initial typing in client.py by @OskarBrzeski in https://github.com/burnash/gspread/pull/1159
Split client http client by @lavigne958 in https://github.com/burnash/gspread/pull/1190
Spelling fix & update docs with date_time_render_option behaviour by @alifeee in https://github.com/burnash/gspread/pull/1187
#966 Add sketch typing for utils.py by @butvinm in https://github.com/burnash/gspread/pull/1196
Remove accepted_kwargs decorator by @lavigne958 in https://github.com/burnash/gspread/pull/1229
Remove/python-3.7 by @alifeee in https://github.com/burnash/gspread/pull/1234
Bump isort from 5.11.4 to 5.12.0 by @dependabot in https://github.com/burnash/gspread/pull/1165
bump flake8 to 6.0.0 by @alifeee in https://github.com/burnash/gspread/pull/1236
merge master into 6.0.0 by @lavigne958 in https://github.com/burnash/gspread/pull/1241
Remplace named tuples with enums by @lavigne958 in https://github.com/burnash/gspread/pull/1250
Feature/add type hints worksheets by @lavigne958 in https://github.com/burnash/gspread/pull/1254
Implement hex color conversion by @idonec in https://github.com/burnash/gspread/pull/1270
remove lastUpdateTime by @alifeee in https://github.com/burnash/gspread/pull/1295
Merge master into feature/release_6_0_0 by @alifeee in https://github.com/burnash/gspread/pull/1320
Add type checking to lint by @alifeee in https://github.com/burnash/gspread/pull/1337
Warning/update swapped args by @alifeee in https://github.com/burnash/gspread/pull/1336
Improve Worksheet.sort() signature by @lavigne958 in https://github.com/burnash/gspread/pull/1342
Make get_values and alias of get by @alifeee in https://github.com/burnash/gspread/pull/1296
fix type issue (remove .first() function) by @alifeee in https://github.com/burnash/gspread/pull/1344
Remove/get records use index by @alifeee in https://github.com/burnash/gspread/pull/1345
increase warning stacklevel from 1 to 2 by @alifeee in https://github.com/burnash/gspread/pull/1361
Feature/merge master by @lavigne958 in https://github.com/burnash/gspread/pull/1371
feature/merge master by @lavigne958 in https://github.com/burnash/gspread/pull/1372
Simplify get records by @alifeee in https://github.com/burnash/gspread/pull/1374
Add util function to_records to build records by @lavigne958 in https://github.com/burnash/gspread/pull/1377
feature/add utils get records by @lavigne958 in https://github.com/burnash/gspread/pull/1378
Add migration guide for get_all_records by @lavigne958 in https://github.com/burnash/gspread/pull/1379
feature/merge master into release 6 0 0 by @lavigne958 in https://github.com/burnash/gspread/pull/1381
Feature/release 6 0 0 by @lavigne958 in https://github.com/burnash/gspread/pull/1382

New Contributors

@cgkoutzigiannis made their first contribution in https://github.com/burnash/gspread/pull/1062
@OskarBrzeski made their first contribution in https://github.com/burnash/gspread/pull/1159
@butvinm made their first contribution in https://github.com/burnash/gspread/pull/1196
@idonec made their first contribution in https://github.com/burnash/gspread/pull/1270

Full Changelog: https://github.com/burnash/gspread/compare/v5.12.4...v6.0.0

v5.12.4

4 months ago

What's Changed

Bump actions/setup-python from 4 to 5 by @dependabot in https://github.com/burnash/gspread/pull/1370
Fixed default value of merge_type parameter in merge_cells function docstring. by @neolooong in https://github.com/burnash/gspread/pull/1373

New Contributors

@neolooong made their first contribution in https://github.com/burnash/gspread/pull/1373

Full Changelog: https://github.com/burnash/gspread/compare/v5.12.3...v5.12.4

v5.12.3

4 months ago

What's Changed

1363 get all records retrieves a large number of empty rows after the end of the data by @alifeee in https://github.com/burnash/gspread/pull/1364

Full Changelog: https://github.com/burnash/gspread/compare/v5.12.2...v5.12.3

v5.12.2

5 months ago

What's Changed

Many fixes for get_records by @alifeee in https://github.com/burnash/gspread/pull/1357
change worksheet.update migration guide by @alifeee in https://github.com/burnash/gspread/pull/1362

Full Changelog: https://github.com/burnash/gspread/compare/v5.12.1...v5.12.2

v5.12.1

5 months ago

What's Changed

feature/readme migration v6 by @lavigne958 in https://github.com/burnash/gspread/pull/1297
add deprecation warnings for lastUpdateTime... by @alifeee in https://github.com/burnash/gspread/pull/1333
remove use_index and references to it in get_records by @alifeee in https://github.com/burnash/gspread/pull/1343
make deprecation warning dependent on if kwarg is used for client_factory by @alifeee in https://github.com/burnash/gspread/pull/1349
fix 1352 expected headers broken by @alifeee in https://github.com/burnash/gspread/pull/1353
fix combine_merged_cells when using from a range that doesn't start at A1 by @alifeee in https://github.com/burnash/gspread/pull/1335

Full Changelog: https://github.com/burnash/gspread/compare/v5.12.0...v5.12.1

v5.12.0

6 months ago

What's Changed

feature -- adding worksheet.get_records to get specific row ranges by @AndrewBasem1 in https://github.com/burnash/gspread/pull/1301
Fix list_spreadsheet_files return value by @mephinet in https://github.com/burnash/gspread/pull/1308
Fix warning message for worksheet.update method by @ksj20 in https://github.com/burnash/gspread/pull/1312
change lambda function to dict (fix pyupgrade issue) by @alifeee in https://github.com/burnash/gspread/pull/1319
allows users to silence deprecation warnings by @lavigne958 in https://github.com/burnash/gspread/pull/1324
Add maintain_size to keep asked for size in get, get_values by @alifeee in https://github.com/burnash/gspread/pull/1305

New Contributors

@AndrewBasem1 made their first contribution in https://github.com/burnash/gspread/pull/1301
@mephinet made their first contribution in https://github.com/burnash/gspread/pull/1308
@ksj20 made their first contribution in https://github.com/burnash/gspread/pull/1312

Full Changelog: https://github.com/burnash/gspread/compare/v5.11.3...v5.12.0

v5.11.3

7 months ago

Fix list_spreadsheet_files return value by @mephinet in https://github.com/burnash/gspread/pull/1308

Full Changelog: https://github.com/burnash/gspread/compare/v5.11.2...v5.11.3