Document Solutions for Excel, .NET Edition | Document Solutions
Features / Data Validations
In This Topic
    Data Validations
    In This Topic

    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:

    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.