See and get the openxlsx options

op.openxlsx

openxlsx_getOp(x, default = NULL)

openxlsx_setOp(x, value)

Format

An object of class list of length 34.

Arguments

x

An option name ("openxlsx." prefix optional)

default

A default value if NULL

value

The new value for the option (optional if x is a named list)

Details

openxlsx_getOp() retrieves the "openxlsx" options found in op.openxlsx. If none are set (currently NULL) retrieves the default option from op.openxlsx. This will also check that the intended option is a standard option (listed in op.openxlsx) and will provide a warning otherwise.

openxlsx_setOp() is a safer way to set an option as it will first check that the option is a standard option (as above) before setting.

Examples

openxlsx_getOp("borders")
#> NULL
op.openxlsx[["openxlsx.borders"]]
#> NULL