Last data update: 2014.03.03
|
R: Set footer for all worksheets
Set footer for all worksheets
Description
Set footer for all worksheets
Usage
setFooter(wb, text, position = "center")
Arguments
wb |
A workbook object
|
text |
footer text. A character vector of length 1.
|
position |
Postion of text in footer. 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, "headerFooterExample.xlsx", overwrite = TRUE)
## End(Not run)
Results
|