pygsheets issues

Any support for updating existing name range?

2

Its probably included, but can anyone give pointers on updating existing named ranges?

ltanedo

question

Create in folder error

4

**Error when creating a spreadsheet in folder (either by id or name)** Have used this feature in the past, but now I can't get it to work. If I omit...

farabolaza

bug

Fix typo in client.py & Added query=None, fid=None parameters to client.open

2

Added query so can filter out opening spreadsheets that are trashed 'trashed=false', also added open to open via file id

Torndeco

Google is deprecating the OOB Oauth2 workflow

4

See: https://developers.googleblog.com/2022/02/making-oauth-flows-safer.html#disallowed-oob I believe this is the auth method used by pygsheets, so this will need to be changed to continue working into the future.

jtroo

enhancement

Add return type annotations when returning classes (i.e. Worksheet)

3

Issue: When calling functions such as Spreadsheet.worksheet_by_title(), which return a custom class (such as Worksheet, Spreadsheet), intellisense cannot provide autocomplete intelligently unless you utilize function chaining. Consider the below: `...

WBETHERI

Worksheet.set_dataframe throws error AttributeError: 'NoneType' object has no attribute 'MultiIndex'

4

```diff # write pandas df to google sheets import pandas as pd import pygsheets as pgs c = pgs.authorize(...) s = c.open_by_key(spreadsheet_id) w = s.sheet1 df = pd.DataFrame({"id":[1,2,3],"val":["A","B","C"]}) print(df.columns) print(isinstance(df.columns,...

mutiev

set_dataframe results in SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame.

When using the set_dataframe to copy in a Pandas dataframe into Googlesheets one gets the standard Python error: ``` worksheet.py:1366: SettingWithCopyWarning: A value is trying to be set on a...

BadrulAlomIOG