DataValidations
Table of Contents
Constants
-
OPERATOR_MAPPINGS
= ['between' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_BETWEEN, 'equal' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_EQUAL, 'greater' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_GREATERTHAN, 'greaterorequal' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_GREATERTHANOREQUAL, 'less' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_LESSTHAN, 'lessorequal' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_LESSTHANOREQUAL, 'notbetween' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_NOTBETWEEN, 'notequal' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_NOTEQUAL]
-
TYPE_MAPPINGS
= ['textlength' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::TYPE_TEXTLENGTH]
Properties
-
$thisColumn
: int
-
$thisRow
: int
Methods
-
loadDataValidations()
: void
-
replaceR1C1()
: string
OPERATOR_MAPPINGS
private
mixed
OPERATOR_MAPPINGS
= ['between' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_BETWEEN, 'equal' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_EQUAL, 'greater' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_GREATERTHAN, 'greaterorequal' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_GREATERTHANOREQUAL, 'less' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_LESSTHAN, 'lessorequal' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_LESSTHANOREQUAL, 'notbetween' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_NOTBETWEEN, 'notequal' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_NOTEQUAL]
TYPE_MAPPINGS
private
mixed
TYPE_MAPPINGS
= ['textlength' => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::TYPE_TEXTLENGTH]
$thisColumn
private
int
$thisColumn
= 0
$thisRow
private
int
$thisRow
= 0
loadDataValidations()
public
loadDataValidations(SimpleXMLElement $worksheet, Spreadsheet $spreadsheet) : void
Parameters
-
$worksheet
: SimpleXMLElement
-
-
$spreadsheet
: Spreadsheet
-
replaceR1C1()
private
replaceR1C1(array<string|int, mixed> $matches) : string
Parameters
-
$matches
: array<string|int, mixed>
-