Function that adds a data frame to an (existing) .xlsx workbook sheet

Usage

add_table(
  Table,
  WbTitle,
  SheetTitle,
  TableTitle,
  StartRow = 1,
  StartCol = 1,
  FormatList = list(),
  HeightTableTitle = 2,
  TableFootnote1 = list(),
  TableFootnote2 = list(),
  TableFootnote3 = list()
)

Arguments

Table: : data frame to be exported to the workbook sheet
WbTitle: : workbook
SheetTitle: : string used for the sheet's name
TableTitle: : string used for the data frame's title
StartRow: : export start line number in the sheet (by default 1)
StartCol: : export start column number in the sheet (by default 1)
FormatList: : list that indicates the format of each column of the data frame
HeightTableTitle: : multiplier (if needed) for the height of the title line (by default 2)
TableFootnote1: : string for TableFootnote1
TableFootnote2: : string for TableFootnote2
TableFootnote3: : string for TableFootnote3

Value

excel wb object