setHeader: Set header for all worksheets

In awalker89/openxlsx: Read, Write and Edit XLSX Files

Description

DEPRECATED

Usage

setHeader(wb, text, position = "center")

Arguments

wb	A workbook object
text	header text. A character vector of length 1.
position	Position of text in header. One of "left", "center" or "right"

Author(s)

Alexander Walker

Examples

## Not run: 
wb <- createWorkbook("Edgar Anderson")
addWorksheet(wb, "S1")
writeDataTable(wb, "S1", x = iris[1:30,], xy = c("C", 5))

## set all headers
setHeader(wb, "This is a header", position="center")
setHeader(wb, "To the left", position="left")
setHeader(wb, "On the right", position="right")

## set all footers
setFooter(wb, "Center Footer Here", position="center")
setFooter(wb, "Bottom left", position="left")
setFooter(wb, Sys.Date(), position="right")

saveWorkbook(wb, "headerHeaderExample.xlsx", overwrite = TRUE)

## End(Not run)

awalker89/openxlsx documentation built on May 11, 2019, 4:09 p.m.