Posted on: 4/28/2015 11:55:27 AM | Views : 696

I have an excel sheet, 1st 3 rows are empty or may have some other heading etc..
The actual Column and data are started from the 4th row. Now I want the read the values and move to a datatable with where condition.
The following is the sample format of the sheet.
Name   Age     Place
aaa         1         xxx
bbb        2         yyy
ccc         3         zzz
ddd       4         rrr
I need to get the data who have Age >1 and move that data into a datatable.
Note: 1st 3 rows may be empty or it may have some headers and some details etc.
I know how to read and move to datatable but for this scenario, I need how to add where condition and how can I mention column name inside the condition
becau ...

Go to the complete details ...