How to get the value in the particular cell dynamically

[anjani_priya]

I have one doubt
in a excel file, there are 22 sheets
the 21 sheets data should sum and should enter in summary sheet
while iam reading the sheets, the summary sheet is also reading how can i ignore that sheet

[anjani_priya]

how to ignore particular sheet

[lrtetala (Lakshman Reddy)]

@anjani_priya

In For each excel sheet Use if condition in that Currentsheet.contains(“Summary”) in that perform your necessary actions

[anjani_priya]

I want to ignore the summary sheet

[lrtetala (Lakshman Reddy)]

@anjani_priya

In then block leave it empty and else block perform your actions

[anjani_priya]

total value column is there but again its showing like total value column is not present

[Anil_G (Anil Gorthi)]

@anjani_priya

Use if condition and if the currentsheet.name is the name of summay then dont do sum

Did you give Total Stock? I see you have value instead

Cheers

[anjani_priya]

the total value column should be sum

[anjani_priya]

iam getting this error.

[Anil_G (Anil Gorthi)]

@anjani_priya

Try to use the formula like this

Dt.AsEnumerable.Sum(function(x) If(IsNumeric(x("ColumnName").ToString), CDBL(x("ColumnName").ToString),0)).ToString

Cheers