Modify the default font
Modify the default font for this workbook
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
## 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 ## Not run: saveWorkbook(wb, "modifyBaseFontExample.xlsx", overwrite = TRUE) ## End(Not run)
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.