• Material
  • Fabric
  • Bootstrap
  • Bootstrap v4
  • High Contrast
Preferences
Theme Selection
Mode Selection
Touch
Mouse
Localization
*Translated by Google Translator.
Currency

Example of Data Validation in ASP.NET MVC XlsIO Control

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

Click the "Create Document" button to view the created Excel document. Please note that the Microsoft Excel viewer or Microsoft Excel is required to view the Excel 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