How to get the cell's format (font and font color) using gspread and pandas

user0qZd1 0
Viewed 25

I used the following code to get the value of a cell in my google sheet:

client = gspread.service_account_from_dict(creds)
hrfile = client.open('HR Data')
hrsheet = hrfile.get_worksheet(0)
H1 = hrsheet.acell('B3').value

How can I get the font and font color of that cell? There is no option like hrsheet.acell('B3').font, hrsheet.acell('B3').format or hrsheet.acell('B3').color

gspread pandas
0 Answers
Related