DsExcel Java allows users to validate cell data via putting a control on its data type, information format and value. You can create separate validation scenarios for a single cell or a range of cells based on your requirements.

With the help of data validation feature, you can execute the following operations in the spreadsheets :

• Make a list of entries via verifying the values that users are allowed to enter in the cells.
• Evoke relevant pop-up messages to validate the description of data values that users can enter in a cell.
• Check whether the entry in a specific cell or a range of cells is accurate or not. This can be done based on the calculated values evaluated on other cells.
• Configure a range of values (numeric or alphabetic) that are allowed to be entered in a single cell or a range of cells.
• Show alert messages when users enter invalid data in the cell.

You can use the data validation feature in DsExcel Java 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