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