DataValidations
Table of Contents
-
OPERATOR_MAPPINGS
= ['between' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_BETWEEN, 'equal' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_EQUAL, 'greater' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_GREATERTHAN, 'greaterorequal' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_GREATERTHANOREQUAL, 'less' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_LESSTHAN, 'lessorequal' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_LESSTHANOREQUAL, 'notbetween' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_NOTBETWEEN, 'notequal' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_NOTEQUAL]
-
TYPE_MAPPINGS
= ['textlength' => PhpOfficePhpSpreadsheetCellDataValidation::TYPE_TEXTLENGTH]
-
$thisColumn
: int
-
$thisRow
: int
-
loadDataValidations()
: void
-
replaceR1C1()
: string
OPERATOR_MAPPINGS
private
mixed
OPERATOR_MAPPINGS
= ['between' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_BETWEEN, 'equal' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_EQUAL, 'greater' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_GREATERTHAN, 'greaterorequal' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_GREATERTHANOREQUAL, 'less' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_LESSTHAN, 'lessorequal' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_LESSTHANOREQUAL, 'notbetween' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_NOTBETWEEN, 'notequal' => PhpOfficePhpSpreadsheetCellDataValidation::OPERATOR_NOTEQUAL]
TYPE_MAPPINGS
private
mixed
TYPE_MAPPINGS
= ['textlength' => PhpOfficePhpSpreadsheetCellDataValidation::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
-
Return values
void
—
replaceR1C1()
private
replaceR1C1(array<string|int, mixed> $matches) : string
Parameters
-
$matches
: array<string|int, mixed>
-
Return values
string
—