The data validation example at Data Validation|Documentation has the following line:
Validation validation = validations[validations.Add(ca)];
However, this doesn’t compile, as there is no ValidationCollection.Add that…...the newer versions of the component, which are more robust and...sample Excel files (you may zip prior attaching here). Also,...