Fill: Create an Fill object.

In xlsx: Read, Write, Format Excel 2007 and Excel 97/2000/XP/2003 Files

Description

Create an Fill object, useful when working with cell styles.

Usage

is.Fill(x)

Fill(
  foregroundColor = "lightblue",
  backgroundColor = "lightblue",
  pattern = "SOLID_FOREGROUND"
)

Arguments

x	a Fill object, as returned by Fill.
foregroundColor	a character vector specifiying the foreground color. Any color names as returned by colors can be used. Or, a hex character, e.g. "#FF0000" for red. For Excel 95 workbooks, only a subset of colors is available, see the constant INDEXED_COLORS_.
backgroundColor	a character vector specifiying the foreground color. Any color names as returned by colors can be used. Or, a hex character, e.g. "#FF0000" for red. For Excel 95 workbooks, only a subset of colors is available, see the constant INDEXED_COLORS_.
pattern	a character vector specifying the fill pattern style. Valid values come from constant FILL_STYLES_.

Value

Fill returns a list with components from the input argument, and a class attribute "Fill". Fill objects are used when constructing cell styles.

is.Fill returns TRUE if the argument is of class "Fill" and FALSE otherwise.

Author(s)

Adrian Dragulescu

See Also

CellStyle for using the a Fill object.

Examples

  fill <-  Fill()

xlsx documentation built on Nov. 10, 2020, 3:52 p.m.