Is There any tool which can help us to read the values from the Excel file and also it should allow us to validate the data in that file
Also, it allows us to customise the application to fit with our requirements? Please respond asap.
I want to give Excel(.xls) or(.xlsx) file as input.
The application should Read the Excel file.
I can set the Datatype of Each column in the application. So that the column should be Validated.
For Eg. If column a's Datatype is "Datetime", it checks all the row of Column "A" for Datettime Datatype. If any other Datatype Value is Present in the Column,it should throw the error.
Is there any kind of Application Created for this in Vb.Net or C#"Windows Application"?
If not,Please give a Detailed idea about how to achieve this....
Thanks and Regards.