writeXLSX: writeXLSX is a convenient way to write dataframes to xlsx...

In West-End-Statistics/r-library-vakdr: Miscellanious helper functions

Description

The default options write a data frame to sheet named after the object name in a file 'data_output.xlsx'. You can write many sheets to the same file by simply passing either differently named objects or passing a different name for the sheet. Note that sheets will be overwritten without warning. New sheet wil always be added to a file (old sheets are not cleared out).

Usage

writeXLSX(
  x,
  file = getOption("vakdr.writeXLSX"),
  sheetName = deparse(substitute(x)),
  col.names = TRUE,
  row.names = FALSE,
  showNA = FALSE,
  addFilter = TRUE,
  autoSize = TRUE
)

Arguments

x	a data.frame.
file	the file name to write to
sheetName	the sheet name to write the data frame to
col.names	a logical value indicating if the column names of x are to be written along with x to the file.
row.names	a logical value indicating whether the row names of x are to be written along with x to the file.
showNA	a boolean value to control how NA's are displayed on the sheet. If FALSE, NA values will be represented as blank cells.
addFilter	should an auto filter be added to each column heading?
autoSize	should each column be autosized?

Examples

## Not run: 
writeXLSX(mtcars)

## End(Not run)

West-End-Statistics/r-library-vakdr documentation built on Dec. 18, 2021, 7:16 p.m.