I would like to validate Excel data according to the following before importing into a database:

1. Some columns have a maximum length
2. Some columns are numbers/dates
3. There must be no special characters

How can i go about this? (I am using C#)

EDIT: How do I validate an Excel column to have a maximum text length using Interop, for example, if I do not want the text to be more than 30 characters long? @JMK @artm @Linger @ivan\_pozdeev @BenR