I need to read excel from 2nd row which contains headers and data is in 3rd row. I had title in row one with merge center! can some one help me ignoring 1st row?


i am using c#
getting error with
headerRowNum=excelresult.Rows.IndexOf( excelresult.AsEnumerable.Where(Function(r) r(0).ToString.Trim.ToUpper = “h1”).ToArray(0) )


modify range to A2 for the read range


Here is the steps.

Step 1: Loop through the DataTable and Increment a loop variable like , LoopCounter=LoopCounter+1;
Step: Inside the loop, check whether LoopCounter values is greater than 2, if so proceed with your process specific steps.

Thank you.