• Material
  • Fabric
  • Bootstrap
  • High Contrast
Preferences
Theme Selection
Mode Selection
Touch
Mouse
Essential JS 2
HOME
All Controls

Button

This sample demonstrates how to use data validation in spreadsheets using XlsIO.
DEMO
SOURCE

Click the button to view an Excel spreadsheet generated by Essential XlsIO. Please note that Microsoft Excel Viewer or Microsoft Excel is required to view the resultant document.


Save As :
      

Data validation helps to control the kind of information that is entered in a worksheet cells. It provides users with the following options:

  • A list of choices
  • Restriction of entries to specific type or size

Essential XlsIO has support for reading and writing data validations. This sample focuses on writing a data validation in an Excel template.

Features:

  • Text validation
  • Validating input text length based on the given constraints