Create Xlsx Files With Cell Data Validation Settings

| August 15, 2020 | 1,139 views | PhpSpreadsheet

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.

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()

References:

0 Comments

Leave a Reply

Your email address will not be published.