create_fill {openxlsx2} | R Documentation |
Create fill pattern
Description
This function creates fill patterns for a cell in a spreadsheet. Fill patterns can be simple solid colors or more complex gradient fills. For certain pattern types, two colors are needed.
Usage
create_fill(
gradient_fill = "",
pattern_type = "",
bg_color = NULL,
fg_color = NULL,
...
)
Arguments
gradient_fill |
Character, specifying complex gradient fills. |
pattern_type |
Character, specifying the fill pattern type. Valid values are "none" (default), "solid", "mediumGray", "darkGray", "lightGray", "darkHorizontal", "darkVertical", "darkDown", "darkUp", "darkGrid", "darkTrellis", "lightHorizontal", "lightVertical", "lightDown", "lightUp", "lightGrid", "lightTrellis", "gray125", "gray0625". |
bg_color |
Character, specifying the background color in hex8 format (alpha, red, green, blue) for pattern fills. |
fg_color |
Character, specifying the foreground color in hex8 format (alpha, red, green, blue) for pattern fills. |
... |
Additional arguments passed to other methods. |
Value
A formatted fill pattern object to be used in a spreadsheet.
See Also
Other style creating functions:
create_border()
,
create_cell_style()
,
create_colors_xml()
,
create_dxfs_style()
,
create_font()
,
create_numfmt()
,
create_tablestyle()
Examples
# Create a solid fill pattern with foreground color
fill <- create_fill(
pattern_type = "solid",
fg_color = wb_color(hex = "FFFF0000")
)