View source: R/class-workbook-wrappers.R
wb_add_fill | R Documentation |
Add fill to a cell region.
wb_add_fill(
wb,
sheet = current_sheet(),
dims = "A1",
color = wb_color(hex = "FFFFFF00"),
pattern = "solid",
gradient_fill = "",
every_nth_col = 1,
every_nth_row = 1,
...
)
wb |
a workbook |
sheet |
the worksheet |
dims |
the cell range |
color |
the colors to apply, e.g. yellow: wb_color(hex = "FFFFFF00") |
pattern |
various default "none" but others are possible: "solid", "mediumGray", "darkGray", "lightGray", "darkHorizontal", "darkVertical", "darkDown", "darkUp", "darkGrid", "darkTrellis", "lightHorizontal", "lightVertical", "lightDown", "lightUp", "lightGrid", "lightTrellis", "gray125", "gray0625" |
gradient_fill |
a gradient fill xml pattern. |
every_nth_col |
which col should be filled |
every_nth_row |
which row should be filled |
... |
... |
The wbWorkbook
object, invisibly
Other styles:
wb_add_border()
,
wb_add_cell_style()
,
wb_add_font()
,
wb_add_named_style()
,
wb_add_numfmt()
,
wb_cell_style
wb <- wb_workbook() %>% wb_add_worksheet("S1") %>% wb_add_data("S1", mtcars)
wb <- wb %>% wb_add_fill("S1", dims = "D5:J23", color = wb_color(hex = "FFFFFF00"))
wb <- wb %>% wb_add_fill("S1", dims = "B22:D27", color = wb_color(hex = "FF00FF00"))
wb <- wb %>% wb_add_worksheet("S2") %>% wb_add_data("S2", mtcars)
gradient_fill1 <- '<gradientFill degree="90">
<stop position="0"><color rgb="FF92D050"/></stop>
<stop position="1"><color rgb="FF0070C0"/></stop>
</gradientFill>'
wb <- wb %>% wb_add_fill("S2", dims = "A2:K5", gradient_fill = gradient_fill1)
gradient_fill2 <- '<gradientFill type="path" left="0.2" right="0.8" top="0.2" bottom="0.8">
<stop position="0"><color theme="0"/></stop>
<stop position="1"><color theme="4"/></stop>
</gradientFill>'
wb <- wb %>% wb_add_fill("S2", dims = "A7:K10", gradient_fill = gradient_fill2)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.