For now, the following image types are supported: dib, emf, jpeg, pict, png, wmf. Please note, that scaling works correctly only for workbooks with the default font size (Calibri 11pt for .xlsx). If the default font is changed the resized image can be streched vertically or horizontally.
addPicture(file, sheet, scale = 1, startRow = 1, startColumn = 1)
the absolute path to the image file.
a worksheet object as returned by createSheet
or by
subsetting getSheets
. The picture will be added on this sheet at
position startRow
, startColumn
.
a numeric specifying the scale factor for the image.
a numeric specifying the row of the upper left corner of the image.
a numeric specifying the column of the upper left corner of the image.
addPicture
a java object references pointing to the picture.
Don't know how to remove an existing image yet.
file <- system.file("tests", "log_plot.jpeg", package = "xlsx")
wb <- createWorkbook()
sheet <- createSheet(wb, "Sheet1")
addPicture(file, sheet)
# don't forget to save the workbook!