Class \avadim\FastExcelWriter\DataValidation\DataValidation

---

• __construct() – DataValidation constructor
• custom() – Make data validation as a custom rule
• date() – Make data validation as a date value
• decimal() – Make data validation as a decimal value
• dropDown() – Make data validation as a dropdown list
• expression() – Make data validation as an expression (alias of self::custom())
• integer() – Make data validation as an integer value
• isNumber() – Checking if a cell value is a number
• isText() – Checking if a cell value is a text
• list() – Alias of dropDown()
• make() – Make a DataValidation instance
• textLength() – Make data validation as a text length
• whole() – Alias of integer()
• allowBlank() – Allow blank value
• setError() – Set error message (title and body)
• setErrorMessage() – Error message body
• setErrorStyle() – Error style (action in case of error)
• setErrorTitle() – Error message title
• setFormula() – Alias of setFormula1()
• setFormula1() – Set formula 1 for data validation
• setFormula2() – Set formula 2 for data validation
• setOperator()
• setPrompt() – Set prompt
• showDropDown() – Show dropdown list
• showErrorMessage() – Allow (or disallow) error message
• showInputMessage() – Show input message

---

__construct()

---

public function __construct($type)

DataValidation constructor

Parameters

• $type

---

custom()

---

public static function custom(string $formula): DataValidation

Make data validation as a custom rule

Parameters

• string $formula

---

date()

---

public static function date(string $operator, $formulas): DataValidation

Make data validation as a date value

Parameters

• string $operator
• string|int|array $formulas

---

decimal()

---

public static function decimal(string $operator, $formulas): DataValidation

Make data validation as a decimal value

Parameters

• string $operator
• string|int|array $formulas

---

dropDown()

---

public static function dropDown($formulas): DataValidation

Make data validation as a dropdown list

Parameters

• array|string $formulas

---

expression()

---

public static function expression(string $formula): DataValidation

Make data validation as an expression (alias of self::custom())

Parameters

• string $formula

---

integer()

---

public static function integer(string $operator, $formulas): DataValidation

Make data validation as an integer value

Parameters

• string $operator
• string|int|array $formulas

---

isNumber()

---

public static function isNumber(): DataValidation

Checking if a cell value is a number

Parameters

None

---

isText()

---

public static function isText(): DataValidation

Checking if a cell value is a text

Parameters

None

---

list()

---

public static function list($formulas): DataValidation

Alias of dropDown()

Parameters

• array|string $formulas

---

make()

---

public static function make($type): DataValidation

Make a DataValidation instance

Parameters

• $type

---

textLength()

---

public static function textLength(string $operator, $formulas): DataValidation

Make data validation as a text length

Parameters

• string $operator
• array|string $formulas

---

whole()

---

public static function whole(string $operator, $formulas): DataValidation

Alias of integer()

Parameters

• string $operator
• string|int|array $formulas

---

allowBlank()

---

public function allowBlank(?bool $allowBlank = true): DataValidation

Allow blank value

Parameters

• bool $allowBlank

---

setError()

---

public function setError(string $errorMessage, 
                         ?string $errorTitle = null): DataValidation

Set error message (title and body)

Parameters

• string $errorMessage
• string|null $errorTitle

---

setErrorMessage()

---

public function setErrorMessage(string $error): DataValidation

Error message body

Parameters

• string $error

---

setErrorStyle()

---

public function setErrorStyle(string $errorStyle): DataValidation

Error style (action in case of error)

Parameters

• string $errorStyle

---

setErrorTitle()

---

public function setErrorTitle(string $errorTitle): DataValidation

Error message title

Parameters

• string $errorTitle

---

setFormula()

---

public function setFormula($formula): DataValidation

Alias of setFormula1()

Parameters

• int|float|string|array|null $formula

---

setFormula1()

---

public function setFormula1($formula): DataValidation

Set formula 1 for data validation

Parameters

• int|float|string|array|null $formula

---

setFormula2()

---

public function setFormula2($formula): DataValidation

Set formula 2 for data validation

Parameters

• int|float|string|array|null $formula

---

setOperator()

---

public function setOperator(string $operator, $formula1, 
                            $formula2): DataValidation

Parameters

• string $operator
• $formula1
• $formula2

---

setPrompt()

---

public function setPrompt(string $promptMessage, 
                          ?string $promptTitle = null): DataValidation

Set prompt

Parameters

• string $promptMessage
• string|null $promptTitle

---

showDropDown()

---

public function showDropDown(?bool $showDropDown = true): DataValidation

Show dropdown list

Parameters

• bool $showDropDown

---

showErrorMessage()

---

public function showErrorMessage(?bool $showErrorMessage = true): DataValidation

Allow (or disallow) error message

Parameters

• bool $showErrorMessage

---

showInputMessage()

---

public function showInputMessage(?bool $showInputMessage = true): DataValidation

Show input message

Parameters

• bool|null $showInputMessage

---