Excel key

Help Robot
,
1

HI Team,
i want to do sum of my D column so how i can do

image
image332×566 11.6 KB

2

HI @Kuldeep_Pandey

Use Assign activity and create the Variable as System.Double

Use this expression in the RHS in Assign activity

(From d in dtData.AsEnumerable Where Not (isNothing(d(3)) OrElse String.IsNullorEmpty(d(3).toString.Trim)) Select v = CDbl(d(3).toString.Trim)).Sum(Function (x) x)

Regards
Gokul

3

Hi,@Kuldeep_Pandey

Use Assign activity and create the Variable as System.Double
var=dt.AsEnumerable.Sum(function(x)cdbl(x(“which column you want”)))

cheers

4

@Kuldeep_Pandey

Another method

dt.AsEnumerable.Sum(function(x) if(IsNumeric(x("Amount").ToString),CDBL(x("Amount").ToString),0)).ToString

Or

dt.Compute("Sum(Amount)", string.Empty).ToString

cheers

5

Not working

6

Its not finding column amount

7

Do you have any error? @Kuldeep_Pandey

8

image

9

Hi @Kuldeep_Pandey

Check out the XAML file

SumExcelColumn.xaml (16.1 KB)

Try with this Instead of 3 you can use Amount in the expression and check it

Regards
Gokul

10

@Kuldeep_Pandey

Column index starts from 0 …so if its column 3 then index will be 2

cheers

11

image
Error
Can we have simple expression to add Column D

12

Have you use Read range activity? With Header enable in the properties?

Regards
Gokul

13

Sorry There is range issue
thanks
kuldeep

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.