Example of Data Validation in ASP.NET Core Excel (XlsIO) Library
This sample demonstrates how to use data validation in spreadsheets using XlsIO.
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.
- Text validation
- Validating input text length based on the given constraints