How to do sum of values for the entire column of different sheets

[anjani_priya]

how to do sum of values for entire column and for different sheets and enter the values at the main sheet linely

[Anil_G (Anil Gorthi)]

@anjani_priya

Please try this

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

Cheers

[anjani_priya]

Iam getting an error
I shared shared the error to you can you check that

[Anil_G (Anil Gorthi)]

@anjani_priya

I saw the error that is when I added an if condition to check for numeric and then get sum

Cheers

[sanjay3 (Sanjay)]

hi @anjani_priya

sumOfColumn = columnData.Where(Function(x) Not String.IsNullOrEmpty(x.ToString)).Select(Function(x) Double.Parse(x.ToString)).Sum()

[anjani_priya]

how to take a particular column in a sheet?

[sanjay3 (Sanjay)]

@anjani_priya

1. Read that excel file (Workbook or Excel Activities)… ( dt_Sheet)
   2.Use Assign Activity
   columnData as List(Of String)= dtSheet.AsEnumerable().Select(Function(row) row(“YourColumnName”).ToString()).ToList()

[anjani_priya]

where is list(of string) data type

[anjani_priya]

getting an error

[sanjay3 (Sanjay)]

@anjani_priya

In the variable panel after naming the variable go to Browse for types

System.Collections.Generic.list

[anjani_priya]

yes I have got but iam getting an error
I want to append 21 sheets