write_excel_image: Write dataframe with image url to excel file with image...

Description Usage Arguments

View source: R/table.R

Description

Write dataframe with image url to excel file with image column

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
write_excel_image(
  df,
  file = tempfile(fileext = ".xlsx"),
  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

file

A character string naming an xlsx file

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.


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