DsExcel .NET provides users with the ability to validate data by restricting the type of information format and the values that can be entered in cells of a worksheet. You can create distinct validation scenarios for individual cells or a range of cells as per your requirements.

Using the data validation feature, you can perform the following tasks in a spreadsheet:

• Generate a list of entries by putting a check on the values allowed in cells.
• Prompt messages to describe the type of data values that can be entered in a cell.
• Figure out if entry in a particular cell or a range of cells is correct or not on the basis of calculations performed on other cells.
• Set a range of values (numeric or alphabetic) allowed in cells or a range of cells.
• Display error alert messages when invalid data is entered in a cell.

You can use the data validation feature in DsExcel .NET to ensure users enter only the valid values into a cell while working in a spreadsheet.

For instance, let's say you have a worksheet where you want users to enter only whole numbers between 1 to 15. To accomplish this, you can create a data validation rule that restricts users to enter cell values other than a whole number between 1 to 15. You can even create custom dropdown lists to specify the possible values that can be entered in the cells or display messages or error alerts to validate the data and get notified if there is something wrong with the information entered in the worksheets.

Applying data validations in worksheets involves the following tasks.

• Add Validations
• Modify Validations
• Delete Validation