In coolbutuseless/image2xlsx: Convert Images to XLSX Spreadsheets

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>",
  fig.path = "man/figures/README-",
  out.width = "100%"
)

image2xlsx

image2xlsx provides a single function to turn an image into an excel (xlsx) spreadsheet.

It stands on the shoulders of the following giants:

• openxlsx
• magick + imagemagick
• dplyr
• tidyr
• raster

Future/ToDo

Patches welcomed!

• Deal with transparency
  • Get magick to flatten transparency to a user-specified background colour?
• ~~Place the image at a desired location~~
• Animation using openxlsx::conditionalFormatting()
  • gifanim2xlsx() ???

Installation

You can install from GitHub with:

# install.packages("devtools")
devtools::install_github("coolbutuseless/image2xlsx")

Rlogo

library(image2xlsx)
image2xlsx("working/RStudio.png", "man/figures/rlogo.xlsx", height = 20, xoffset = 3, yoffset = 3)

A screenshot of rlogo.xlsx opened in LibreOffice

knitr::include_graphics("man/figures/rlogo.png")

Bender Bending Rodríguez

library(image2xlsx)
image2xlsx("working/bender.jpg", "man/figures/bender.xlsx")

A screenshot of bender.xlsx opened in LibreOffice

knitr::include_graphics("man/figures/bender.png")

Grappling Hook!

library(image2xlsx)
image2xlsx("working/mabel.png", "man/figures/mabel.xlsx")

A screenshot of mabel.xlsx opened in LibreOffice

knitr::include_graphics("man/figures/mabel.png")

coolbutuseless/image2xlsx documentation built on May 23, 2019, 1:59 a.m.