• Fluent
  • Fluent Dark
  • Bootstrap v5
  • Bootstrap v5 Dark
  • Tailwind CSS
  • Tailwind CSS Dark
  • Material
  • Bootstrap v4
  • High Contrast
Preferences
Mode Selection
Touch
Mouse
Theme Selection
Localization
*Translated by Google Translator.
Currency
Essential Studio
HOME
All Controls

Example of Data Validation in ASP.NET Core Excel (XlsIO) Library

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