
Last chance! 50% off unlimited learning
Sale ends in
change background color of selected rows and columns of a flextable.
bg(x, i = NULL, j = NULL, bg, part = "body", source = j)
a flextable object
rows selection
columns selection
color to use as background color. If a function, function need to return a character vector of colors.
partname of the table (one of 'all', 'body', 'header', 'footer')
if bg is a function, source is specifying the dataset column to be used
as argument to bg
. This is only useful if j is colored with values contained in another
(or other) column.
Other sugar functions for table style:
align()
,
bold()
,
color()
,
empty_blanks()
,
fontsize()
,
font()
,
highlight()
,
italic()
,
line_spacing()
,
padding()
,
rotate()
,
valign()
# NOT RUN {
ft_1 <- flextable(head(mtcars))
ft_1 <- bg(ft_1, bg = "wheat", part = "header")
ft_1 <- bg(ft_1, i = ~ qsec < 18, bg = "#EFEFEF", part = "body")
ft_1 <- bg(ft_1, j = "drat", bg = "#606060", part = "all")
ft_1 <- color(ft_1, j = "drat", color = "white", part = "all")
ft_1
if(require("scales")){
ft_2 <- flextable(head(iris))
colourer <- col_numeric(
palette = c("wheat", "red"),
domain = c(0, 7))
ft_2 <- bg(ft_2, j = c("Sepal.Length", "Sepal.Width",
"Petal.Length", "Petal.Width"),
bg = colourer, part = "body")
ft_2
}
# }
Run the code above in your browser using DataLab