almn
December 26, 2023, 2:50pm
1
Hello!
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!
AlexisW
December 27, 2023, 5:33pm
2
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
system
Closed
January 17, 2024, 8:55pm
4
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.