Get data validations

• Extension version 1.6.0 or later;

• Build with --enable-reader;

Returns every <dataValidation> element on the active worksheet — the read-side counterpart of the Validation writer class.

Methods

getDataValidations(): ?array

Return value

An array of validation entries, each with:

• type (string) — whole, decimal, list, date, time, textLength, custom;

• operator (string|null) — between, equal, greaterThan, ...;

• error_style (string|null) — stop, warning, information;

• formula1 (string|null) — first formula / list source;

• formula2 (string|null) — second formula;

• prompt (string|null) — input prompt body;

• prompt_title (string|null) — input prompt title;

• error (string|null) — error message body;

• error_title (string|null) — error message title;

• sqref (string) — applied range, e.g. A1:A10;

• allow_blank (bool) — whether blanks are allowed;

• show_drop_down (bool) — whether the drop-down arrow is shown (note: inverted in XML);

• show_input_message (bool) — whether to show the input prompt;

• show_error_message (bool) — whether to show the error message.

Example

$config = ['path' => './tests'];
$excel  = new \Vtiful\Kernel\Excel($config);

$dvs = $excel->openFile('source.xlsx')
    ->openSheet()
    ->getDataValidations();

print_r($dvs);