changing the typset of strings read into a google sheet

Question

I'm relatively new to python, but is there a way to make the values one reads into their spreadsheet bold? I want to create headers that have a bold typeset, but I'm not sure how to do this.

Thank you!

Here is the statement I am trying to do this with. I want to make the strings in 'row' boldfaced when they read into my spreadsheet

#read in header values
row = ['Group ID','N. of Galaxies','Central RA','Central DEC','Central z','Group Span From Center (MPC/h)']
index = 1
#sheet.insert_row(row, index)

Katiya, I would advice you to include some code you have tried into your question, else, you might end with your question flagged and removed. — acarlstein, Jun 27 '20 at 21:08
@acarlstein Thank you for letting me know! I've changed it above — Katiya Fosdick, Jun 30 '20 at 00:48

score 0 · Answer 1 · answered Jul 24 '20 at 00:33

Try adding the line below.

sheet.format('A1:A6', {'textFormat': {'bold': True}})

And change the a1 notation to match the width of your header row. That should do the trick!

More details at: https://gspread.readthedocs.io/en/latest/user-guide.html#formatting

changing the typset of strings read into a google sheet

1 Answers1