Description Usage Arguments Details Author(s) Examples
Modify the default font for this workbook
1 2 | modifyBaseFont(wb, fontSize = 11, fontColour = "black",
fontName = "Calibri")
|
wb |
A workbook object |
fontSize |
font size |
fontColour |
font colour |
fontName |
Name of a font |
The font name is not validated in anyway. Excel replaces unknown font names with Arial. Base font is black, size 11, Calibri.
Alexander Walker
1 2 3 4 5 6 7 8 9 | ## create a workbook
wb <- createWorkbook()
addWorksheet(wb, "S1")
## modify base font to size 10 Arial Narrow in red
modifyBaseFont(wb, fontSize = 10, fontColour = "#FF0000", fontName = "Arial Narrow")
writeData(wb, "S1", iris)
writeDataTable(wb, "S1", x = iris, startCol = 10) ## font colour does not affect tables
saveWorkbook(wb, "modifyBaseFontExample.xlsx", overwrite = TRUE)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.