xlsx: Fill – R documentation

Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

Fill

Create an Fill object.

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

is.Fill(x)

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

`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_`.

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.

Adrian Dragulescu

fill <-  Fill()

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

v0.6.5

GPL-3

Authors

Adrian Dragulescu [aut], Cole Arendt [aut, cre]

Initial release