xlsx: Picture – R documentation

Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

Picture

Functions to manipulate images in a spreadsheet.

Description

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.

Usage

addPicture(file, sheet, scale = 1, startRow = 1, startColumn = 1)

Arguments

`file`	the absolute path to the image file.
`sheet`	a worksheet object as returned by `createSheet` or by subsetting `getSheets`. The picture will be added on this sheet at position `startRow`, `startColumn`.
`scale`	a numeric specifying the scale factor for the image.
`startRow`	a numeric specifying the row of the upper left corner of the image.
`startColumn`	a numeric specifying the column of the upper left corner of the image.

Details

Don't know how to remove an existing image yet.

Value

addPicture a java object references pointing to the picture.

Author(s)

Adrian Dragulescu

Examples

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!

xlsx

Read, Write, Format Excel 2007 and Excel 97/2000/XP/2003 Files

v0.6.5

GPL-3

Authors

Adrian Dragulescu [aut], Cole Arendt [aut, cre]

Initial release