xls_theme_plain: Constructor function for a plain xls theme

In tablexlsx: Export Data Frames to Excel Workbook

Constructor function for a plain xls theme

Description

This function is a wrapper around [xls_theme()] that creates an xls theme for styling exported tables. It defines a simple theme whith no special formatting. All its arguments must be 'openxlsx' Style objects.

Usage

xls_theme_plain(
  title = openxlsx::createStyle(),
  col_header = openxlsx::createStyle(),
  character = openxlsx::createStyle(),
  footnote1 = openxlsx::createStyle(),
  footnote2 = openxlsx::createStyle(),
  footnote3 = openxlsx::createStyle(),
  mergedcell = openxlsx::createStyle(),
  ...
)

Arguments

title	Style for the title
col_header	Style for the columns header
character	Default style for data cells
footnote1	Style for footnote1
footnote2	Style for footnote2
footnote3	Style for footnote3
mergedcell	Style for merged cells
...	Other (named) custom styles

Value

a named list of class xls_theme, whose elements are 'openxlsx' Style objects.

See Also

xls_theme(), xls_theme_default()

Examples

# plain theme
xls_theme_plain()

# plain theme with title in bold
my_theme <- xls_theme_plain(title = openxlsx::createStyle(textDecoration = "bold"))

## Not run: 
toxlsx(object = iris, path = tempdir(), theme = my_theme)

## End(Not run)

tablexlsx documentation built on Oct. 16, 2024, 5:08 p.m.