Pygsheets Versions Save

Google Sheets Python API v4

2.0.6

1 year ago

2.0.5

3 years ago
  • Bug fixes
  • added batch value update
  • changed default behavior of get_as_df ref breaking change

2.0.4

3 years ago

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

4 years ago

hotfix for worksheet indexing issue. reverted the indexing to start from index 0

2.0.3

4 years ago

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

4 years ago

added cell merging and un-merging for a range added automatically resize rows / columns based on content added custom http object passing on auhtorization

other bug fixes

Contributors : @daverck

2.0.1

4 years ago

bug fixes

2.0.0

5 years ago

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

@Kordishal @ssg2526

1.1.4

6 years ago

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

6 years ago
  • Added Teamdrive support
  • Added cell text alignment
  • Improved Datarange support
  • Other bug fixes