0

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

Mary
  • 231
  • 1
  • 3
  • 12
  • Does this answer your question? [Reading an excel with pandas basing on columns' colors](https://stackoverflow.com/questions/44861989/reading-an-excel-with-pandas-basing-on-columns-colors) – eshirvana Sep 15 '22 at 12:58
  • 1
    @eshirvana - Google Sheets is not Microsoft Excel. – BigBen Sep 15 '22 at 12:58
  • 1
    Before I noticed this question, I have posted an answer to [your this question](https://stackoverflow.com/a/73738358). I apologize for this. Could you please confirm it? – Tanaike Sep 15 '22 at 23:39

0 Answers0