-
Notifications
You must be signed in to change notification settings - Fork 944
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Get cell colors and other decorations #1313
Labels
Comments
Hi I'm sorry but I don't understand where is the issue with gspread. Did you try to use gspread to get the data and the cell values ? |
There are no problems with gspread, I marked this issue as a Feature Request |
I see, you might be looking for the package gspread-format then |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
In my task, I need to get the color of the cell and different logic will be executed from the color.
I managed to find a small amount of information on how to get such data, namely, to pass the includeGridData parameter with the value true to the get method. Finded solution. Code example of working prototype
acc
its service_accountresult of
pprint(data.json()['sheets'][0]['data'][0]['rowData'][0]['values'][0]['effectiveFormat'])
The
'values'
key stores data for a specific row specified in the range, and'rowData'
stores all rows specified in the range.The text was updated successfully, but these errors were encountered: