Questions tagged [gspread-formatting]
6 questions
0
votes
0 answers
How to get cell color in google sheet using gspread python
I wanted to fetch cell color using gspread and apply this color to another cell but I am unable to find a way to extract cell color using gspread-formatting
0
votes
1 answer
Hide gridlines with the Google Sheets API in Python
I want to remove all the gridlines in my google sheet. I think I need to use batchupdate in combination with a JSON request that sets the hideGridlines in gridProperties to True but I can't seem to get it to work.
Anyone knows how to do this?
This…
user20300605
- 5
- 2
0
votes
1 answer
Format a specific cell with currency rounded format using gspread in python
I am currently using this
sheet.format("C3:C3", {"numberFormat": {"type": "CURRENCY"}})
But it doesn't seem to work
Md. Shahriyar Alam
- 13
- 1
- 8
0
votes
1 answer
Set RTL for Google sheet in Python
Is there a way to set RTL (Right-to-left) and LTR (left-to-right) to sheets/cells in Python, perhaps with gspread or gspread-formatting packages? Does Google Sheet's API even support this?
I couldn't find any related documentation...
UPDATE: I…
Jonathan Livni
- 101,334
- 104
- 266
- 359
-1
votes
1 answer
gspread: Retrieve dimensions (width/height) of columns and rows
I am trying to retrieve the dimensions of columns and rows in my spreadsheet via the gspread python library.
I am able to authenticate API access, and I can access/modify cell values. I am also able to resize rows and columns. However, I do not seem…
Adam Higgins
- 103
- 3