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 ...