Calculate sum of excel column

Help
,
4

@saili,
Try the following inside an assign activity,

 yourDataTable.AsEnumerable().Sum(Function(r) r.Field(Of Integer)("yourColumnName"))

For this you need to read your excel data as a datatable using Excel application scope