I have a handsontable like this in place of Default value if i add something (for ex: Client Name as Test) it should validate that record it should not accept numbers and for period end date it should accept date .
Have you tried custom validators? https://handsontable.com/docs/7.0.0/demo-data-validation.html
@wojciech.czerniak this is not solving my problem in this solution we have to give validator to column headers but for my solution we are validating row fields not for column header
Validators are for cells. You can define them on column so you don't have to do that for each cell.
Can you describe what you want to do? Maybe I misunderstood something.
My requirement is i need to validate client name and when i enter the value of client name in default value column it should accept only letters if i enter numbers it should show error message and next for Responsible Person i need to validate as it should take email id as value
this sounds like a job for regex. To check how to use it please go to https://handsontable.com/blog/articles/2018/10/advanced-data-validation-in-handsontable. There's a JSFiddle demo and a description in the Mixed values – Regex**strong text** section.
Mixed values – Regex**strong text**
the above solution works for same headers for me i need to validate for row value not for header in your solution for default value if i apply validation it will take only that particular validation (for ex: i can give phone number validation ) and for the same column what if i need to give only alphabets for client name it will not accept right . see the above fig. you may get how i want to validate the fields
The example was made for a particular case, in your example you'd need to create your own regex expression. Here is a generator that you can use https://regexr.com/