xlcharts (version 0.0.1)

DataValidation: DataValidation

Description

https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.datavalidation.html

Usage

DataValidation(
  type = NULL,
  formula1 = NULL,
  formula2 = NULL,
  showErrorMessage = FALSE,
  showInputMessage = FALSE,
  showDropDown = FALSE,
  allowBlank = FALSE,
  sqref = list(),
  promptTitle = NULL,
  errorStyle = NULL,
  error = NULL,
  prompt = NULL,
  errorTitle = NULL,
  imeMode = NULL,
  operator = NULL,
  allow_blank = FALSE,
  ...
)

Value

An openpyxl Python object.

Arguments

type

type

formula1

formula1

formula2

formula2

showErrorMessage

showErrorMessage

showInputMessage

showInputMessage

showDropDown

showDropDown

allowBlank

allowBlank

sqref

sqref

promptTitle

promptTitle

errorStyle

errorStyle

error

error

prompt

prompt

errorTitle

errorTitle

imeMode

imeMode

operator

operator

allow_blank

allow_blank

...

Additional arguments, i.e. kwargs.

Examples

if (FALSE) {
DataValidation()
}