openxlsx2 (version 0.8)

wb_add_form_control: Add form control Checkbox, Radiobuttons or Dropmenu

Description

Add form control Checkbox, Radiobuttons or Dropmenu

Usage

wb_add_form_control(
  wb,
  sheet = current_sheet(),
  dims = "A1",
  type = NULL,
  text = NULL,
  link = NULL,
  range = NULL,
  checked = FALSE
)

Value

The wbWorkbook object

Arguments

wb

A workbook object

sheet

A worksheet of the workbook

dims

Optional row and column as spreadsheet dimension, e.g. "A1"

type

A type "Checkbox" (the default), "Radio" a radio button or "Drop" a drop down menu

text

A text to be shown next to the Checkbox or radio button

link

A cell range to link to

range

A cell range used as input

checked

A logical indicating if the Checkbox or radio button is checked

Examples

wb <- wb_workbook() %>% wb_add_worksheet() %>%
  wb_add_form_control()