add a plot output as vector graphics into an Excel object — xl_add_vg • rvg

produces a vector graphics output from R plot instructions and add the result in an Excel sheet. by read_xlsx.

Usage

xl_add_vg(x, sheet, code, left, top, width, height, ...)

Arguments

x: an rxlsx object produced by officer::read_xlsx
sheet: sheet label/name
code: plot instructions
left, top: left and top origin of the plot on the slide in inches.
height, width: Height and width in inches.
...: arguments passed on to dml_xlsx.

Examples

# \donttest{
library(officer)
my_ws <- read_xlsx()
my_ws <- xl_add_vg(my_ws,
  sheet = "Feuil1",
  code = barplot(1:5, col = 2:6), width = 6, height = 6, left = 1, top = 2
)
fileout <- tempfile(fileext = ".xlsx")
print(my_ws, target = fileout)
# }