Skip to contents

Style data according to its type

Usage

style_data(
  data_type,
  wb,
  sheet_name,
  rows,
  cols,
  no_show = FALSE,
  no_show_row = 0,
  fade = FALSE,
  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", "chr_type", or "formula".

wb

a openxlsx workbook to be edited.

sheet_name

character name of the sheet to update

rows

Rows to apply style to.

cols

columns 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