create_workbook_sku_image: Create a workbook for dataframe with sku image

Description Usage Arguments Value

View source: R/table.R

Description

Create a workbook for dataframe with sku image

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
create_workbook_sku_image(
  df,
  df_image_url_col_name = "图片",
  df_image_title_col_name = "SKU",
  image_save_path = getOption("sku_image_save_path", "~/images"),
  widths = 27,
  heights = 144,
  width = 5,
  height = 5,
  units = "cm",
  dpi = 300
)

Arguments

df

a tbl or dataframe

df_image_url_col_name

Column name of image url

df_image_title_col_name

Column name of image title

image_save_path

The path images saved to.

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.

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.

Value

an openxlsx workbook


shizidushu/shinycomp documentation built on Sept. 15, 2020, 11:30 a.m.