Take advantage of one of the powerful feature of an xlsx file, the ‘Data Validation’. This will grant the ability to define an input filter on the data that a user can insert in a particular cell. The filter can be a value that must be between a certain start data and specific end data, for example, a value between 100 and 200 will only be allowed to be entered on a selected cell. Greater than a given value, or lower than a set value can also be set as a filter.
But before moving further in coding a data validation in PhpSpreadsheet, it would be better to read and familiarize oneself with the available options such as the ‘Constants’, ‘Properties’, and ‘Methods’, to be able to have a wider-look of the coding possibilities in creating an xlsx file with data validation using PhpSpreadsheet.
Below are the available cell data validation options of PhpSpreadsheet.
Note:
For the complete documentation, head over to the PhpSpreadsheet Cell Data Validation page.
Constants
- TYPE_NONE
- TYPE_CUSTOM
- TYPE_DATE
- TYPE_DECIMAL
- TYPE_LIST
- TYPE_TEXTLENGTH
- TYPE_TIME
- TYPE_WHOLE
- STYLE_STOP
- STYLE_WARNING
- STYLE_INFORMATION
- OPERATOR_BETWEEN
- OPERATOR_EQUAL
- OPERATOR_GREATERTHAN
- OPERATOR_GREATERTHANOREQUAL
- OPERATOR_LESSTHAN
- OPERATOR_LESSTHANOREQUAL
- OPERATOR_NOTBETWEEN
- OPERATOR_NOTEQUAL
Properties
- $formula1
- $formula2
- $type
- $errorStyle
- $operator
- $allowBlank
- $showDropDown
- $showInputMessage
- $showErrorMessage
- $errorTitle
- $error
- $promptTitle
- $prompt
Methods
- __construct()
- getFormula1()
- setFormula1()
- getFormula2()
- setFormula2()
- getType()
- setType()
- getErrorStyle()
- setErrorStyle()
- getOperator()
- setOperator()
- getAllowBlank()
- setAllowBlank()
- getShowDropDown()
- setShowDropDown()
- getShowInputMessage()
- setShowInputMessage()
- getShowErrorMessage()
- setShowErrorMessage()
- getErrorTitle()
- setErrorTitle()
- getError()
- setError()
- getPromptTitle()
- setPromptTitle()
- getPrompt()
- setPrompt()
- getHashCode()
- __clone()
Leave a Reply