Is it possible to get cell style in google sheets with googlesheets4 or any other package?


I want to read google sheet in R Studio with the cell fill colors / cell styles but can't find a way to do that.

Some cells in google sheet are empty but filled with the colors. Is it possible to read this colors in some way?

Or even more complicated situation when a cell contains black and red text. Is it possible to identify red one?

Thank you!

I don't have direct experience with the package, but it seems range_read_cells() with its arguments cell_data = "full", discard_empty = FALSE will give you all the formatting. That should be in the CellFormat field.

1 Like

Huge thanks, that works!

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.