Skip to contents

Style data single data column according to its type

Usage

style_data_single(
  data_type = c("numeric", "integer", "Date", "character", "chr_type", "formula"),
  wb,
  sheet_name,
  rows,
  col,
  no_show = FALSE,
  no_show_row = 0,
  fade = TRUE,
  fade_row = 0
)

Arguments

data_type

character vector of class(es) of the data to be styled. Can be one of "numeric", "integer", "Date", "character", or "chr_type"

wb

a openxlsx workbook to be edited.

sheet_name

character name of the sheet to update

rows

Rows to apply style to.

col

Column to apply style to.

no_show

Boolean with TRUE if data in no_show_row should be displayed

no_show_row

integer identifying which row contains data no to show

fade

Boolean with TRUE if rows in fade_row should be faded

fade_row

integer identifying which row contains data no to show