Releases: nithinmurali/pygsheets
2.0.6
2.0.5
2.0.4
data validation support added
added conditional formatting
metadata support added @dankrause
added metadata search @dankrause
improved files api support @dankrause
Added batch get (now you can fetch multiple ranges in single request)
hyperlink support
Added batchmode in client (Better api merging support)
added support for specifying parent folder name in create
bug fixes
2.0.3.1
hotfix for worksheet indexing issue. reverted the indexing to start from index 0
2.0.3
Changed how cell addressing is handled
Added Address
Added Grid Range
Now all range implementations use this addressing
Now Datarange supports unbounded ranges
Added update call batching while un-linked
Docs Improved
Other bug fixes
2.0.2
2.0.1
bug fixes
2.0.0
This version is not backwards compatible with 1.x
There is major rework in the library with this release.
Some functions are renamed to have better consistency in naming and clear meaning.
- update_cell() renamed to update_value()
- update_cells() renamed to update_values()
- update_cells_prop() renamed to update_cells()
- changed authorize() params : outh_file -> client_secret, outh_creds_store ->credentials_directory, service_file -> service_account_file, credentials -> custom_credentials
- teamDriveId, enableTeamDriveSupport changed to client.drive.enable_team_drive, include_team_drive_items
- parameter changes for all get_* functions : include_empty, include_all changed to include_tailing_empty, include_tailing_empty_rows
- parameter changes in created_protected_range() : gridrange param changed to start, end
- remoed batch mode
- find() splited into find() and replace()
- removed (show/hide)_(row/column), use (show/hide)_dimensions instead
- removed link/unlink from spreadsheet
New Features added
- chart Support added
- sort feature added
- better support for protected ranges
- multi header/index support in dataframes
- removes the dependency on oauth2client and uses google-auth and google-auth-oauth.
Other bug fixes and performance improvements
Credits
1.1.4
Better Multi-index support for dataframe
Better Team Drive Support
Update cell list with properties
Fixed authorization issue in windows
share sheet with anyone
protected range support, added visibility controls
frozen row/col support
dimension visibility controls
added batch update only for cell properties
other bug fixes
1.1.3
- Added Teamdrive support
- Added cell text alignment
- Improved Datarange support
- Other bug fixes