create_workbook_sku_image: Create a workbook for dataframe with sku image

Description Usage Arguments Value

View source: R/write.R

Description

Create a workbook for dataframe with sku image

Usage

1
2
3
4
create_workbook_sku_image(df, df_image_title_col_name,
  df_image_url_col_name, image_col_name = "Image", widths = 27,
  heights = 144, image_file_extension = ".JPG", width = 5,
  height = 5, units = "cm", dpi = 300, image_path = "~/images")

Arguments

df

a tbl or dataframe

df_image_title_col_name

the colname of the image title (usually the sku)

df_image_url_col_name

the colname of image url column

image_col_name

the colname for the image in df

widths

widths to set cols to specified in Excel column width units or "auto" for automatic sizing. The widths argument is recycled to the length of cols.

heights

Heights to set rows to specified in Excel column height units.

image_file_extension

the file extension of the image

width

Width of figure.

height

Height of figure.

units

Units of width and height. Can be "in", "cm" or "px"

dpi

Image resolution used for conversion between units.

image_path

where the image locates; default to ~/images

Value

an openxlsx workbook


shizidushu/hfun documentation built on Aug. 27, 2018, 8 a.m.