auto_df_to_wb: Take a data.frame in r and output an openxlsx wb object

In moj-analytical-services/xltabr: Automatically Write Beautifully Formatted Cross Tabulations/Contingency Tables to Excel

Description

Take a data.frame in r and output an openxlsx wb object

Usage

auto_df_to_wb(df, auto_number_format = TRUE, titles = NULL,
  footers = NULL, left_header_colnames = NULL, vertical_border = TRUE,
  auto_open = FALSE, return_tab = FALSE, auto_merge = TRUE,
  insert_below_tab = NULL)

Arguments

df	The data.frame to convert to Excel
auto_number_format	Boolean. Whether to automatically detect number formats of columns
titles	Character vector of titles. One element per row of title.
footers	Table footers. A character vector. One element per row of footer.
left_header_colnames	The names of the columns that you want to designate as left headers
vertical_border	Boolean. Do you want a left border?
auto_open	Boolean. Automatically open Excel output.
return_tab	Boolean. Return a tab object rather than a openxlsx workbook object
auto_merge	Boolean. Whether to merge cells in the title and footers to width of body
insert_below_tab	A existing tab object. If provided, this table will be written on the same sheet, below the provided tab.

Examples

wb <- auto_crosstab_to_wb(mtcars)

moj-analytical-services/xltabr documentation built on May 9, 2019, 9:59 p.m.