xlsx.addHeader: Adds a header to a .xlsx file

In mananshah99/xlsxboost: What the package does (short line)

Description

Makes use of numerous parameters including the sheet, text, HTML heading level, and color to display a header on an excel workbook

Usage

xlsx.addHeader(wb, sheet, value = "Header", level = 1, color = "#FFFFFF",
  startRow = NULL, startCol = 2)

Arguments

wb	The excel workbook
sheet	The excel sheet (created by xlsxBoost)
value	The header value specified
level	The HTML header level
color	The hex color code
startRow	The row to start the header on
startCol	The column to start the header on

Examples

wb <- createWorkbook(type="xlsx")
sheet <- xlsx::createSheet(wb, sheetName = "example")
xlsx.addHeader(wb, sheet, value="Header 1",level=1, color="black")
saveWorkbook(wb, "example.xlsx")
xlsx.openFile("example.xlsx") # view the file

mananshah99/xlsxboost documentation built on May 21, 2019, 11:23 a.m.