DataValidation

Source code

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,
  ...
)

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.

Value

An openpyxl Python object.

Examples

library("xlcharts")

DataValidation()