Use message box to display Sum data in Excel file

[meli]

Hello! i need to sum up one column in excel and display them in a message box as “total price is ____” how do i do that?

[rikulsilva (Henrique Lima da Silva)]

Hi @meli

Use Read Range Workbook to read your excel

create a variable called totalPrice as string

in assign activity, use

totalPrice = your_dt_variable.AsEnumerable.Sum(Function (x) CDbl(x(“Price”).toString.Trim).ToString

Then use it in your Message Box the totalPrice variable

[meli]

what do i enter here

it says activity us only valid inside excel application scope

[rikulsilva (Henrique Lima da Silva)]

Use this one

Read Range Workbook from Workbook Activities

Then pass the full path of Excel File and the Sheet Name

[meli]

Ah, i think i do not have that activity

[rikulsilva (Henrique Lima da Silva)]

Coud you share screenshot of project dependencies ?

[meli]

[rikulsilva (Henrique Lima da Silva)]

Update your Excel Package activity and System Activity from Manage Packages:

[meli]

do i copy the ‘x’ and CDbl?
i have no idea whats that, could you explain please?

[rikulsilva (Henrique Lima da Silva)]

@rikulsilva

your_dt_variable.AsEnumerable.Sum(Function (x) CDbl(x(“Price”).toString.Trim).ToString

Please use the workflow attached as reference

SumExcelColumn.zip (49.0 KB)

[ppr (Peter Preuss)]

@rikulsilva

AsEnumerable.Sum(Function (x)

@meli

i have no idea whats that,

the code line is about LINQ

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…

x acts like like a local variable representing the looped Datarow like
For each row in DataTable Acitvity

Also have a look here

[HowTo] LINQ - First Start # Min | Max | Sum | Average Operator

This HowTo gives an introductory overview of the aggregation Operators: Min, Max, Sum, Average Introduction The aggregation operators are used to retrieve from a collection a particular result by setting the contained items into a relationship. Overview I – Input P – Processing O – Output {2,12,-8,6,14,5} get the lowest value -8 {2,12,-8,6,14,5} get the highest value 14 {2,12,-8,6,14,5} sum up all values 31 {2,12,-8,6,14,5} get the average of all values 5.17 Constraints P…

[meli]

It says document invalid .(

[rikulsilva (Henrique Lima da Silva)]

Could you share some screenshot ?

[meli]

By any chance do you have another workflow i can refer to?

[rikulsilva (Henrique Lima da Silva)]

Could you share what Studio version are you work with ?

[Anil_G (Anil Gorthi)]

@meli

1. First drag excel application scope and give the excel path there …inside that activity drag read range and use it…that should solve the issue

To get sum use this in message box dt.AsEnumerable.Sum(function(x) cdbl(x("Price").ToString)).ToString

Where dt is the output of read range activity

Cheers

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @meli ,

Is this your expect output?
SumBox.zip (9.0 KB)
This is source
Regards

[meli]

Yes!! this is what i need to get!! how do u do that

[meli]

what do i write for ‘x’ or do i js keep it as ‘x’

[meli]

I am sorrh i am not sure