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…...sample Excel files (you may zip prior attaching here). Also,...