Set cell format in google spreadsheet using python api

Question

I am using gd_client.UpdateCell to update values in a google spreadsheet and am looking for a way to update the formatting of the cell i.e. color, lines, textsize.....

Can this be done?

Are there examples or other documentation available?

Anything to get me going would be great

Answer 1

I don't think this can be done currently. The current APIs (both the List and Cell API) allow changing data, but not formatting.

The entire APIs are described here. Nothing about formatting:

• http://code.google.com/apis/spreadsheets/data/3.0/reference.html
• http://code.google.com/apis/documents/docs/3.0/reference.html

Many people requesting this in the groups but never get an answer from Google:

• http://groups.google.com/group/Google-Docs-Data-APIs/browse_thread/thread/14aef72447ba48ce/9c2143fb4c8a3000?lnk=gst&q=color#9c2143fb4c8a3000
• http://www.mail-archive.com/[email protected]/msg02569.html