How to get specific cell value and based that value, I need to fetch next row of the data.?

[shuklarchana001]

Hello All,

I am trying fetch data from excel but it giving 0 instead of real value.

Using query:- Convert.ToInt32(DT.AsEnumerable().Where(Function(w) w(0).ToString.Contains(“Total Payments:”)).Select(Function(s) s.ItemArray.Where(Function(sw) sw.ToString.IsNumeric).FirstOrDefault).FirstOrDefault())

Screen:-

[shuklarchana001]

And I am adding dummy sheet.

Dummy Data.xlsx (12.5 KB)

Any help on this issue??

[Yoichi]

Hi,

In this case, the following will work, because “Total Payments:” exists in not ColumnA(column #0 of DT) but ColumnJ (column#9 of DT).

Convert.ToInt32(DT.AsEnumerable().Where(Function(w) w(9).ToString.Contains("Total Payments:")).Select(Function(s) s.ItemArray.Where(Function(sw) sw.ToString.IsNumeric).FirstOrDefault).FirstOrDefault())

Regards,