Issue with the sum in excel

Help
1

Hello

I’m trying sum the values an Excel column with the activity “For each row” and although the sum is well done, the process never end and have to reset Uipath. Attach the process for you can helpme what is causing the error.

for each.xaml (42.4 KB)

Libro1.xlsx (237.5 KB)

Thank you very much for help!

2

Hi,

@Braki

instead forloop you can use LINQ.

use below code to get sum of the column

Convert.ToString(BaseTotal.AsEnumerable().Sum(Function(row) row.Field(Of Double)(“Importes”)))

for each.xaml (39.4 KB)
use this xaml file @Braki
Regards,
Arivu

3

Hi,

@arivu96, when try prove your process I received the following message:

columna

the column exists and the name is correct

thanks for the help again

4

@Braki, do you have “Add Headers” checked on your Read Range?

5

Hi @Braki
In Read range activity ->properties-> Add header check box need to check.
(Refer the xaml what I send to you)

Regards,
Arivu

6

yes that option is activated!

7

HI,
@Braki refer this xaml.

for each.xaml (39.4 KB)

Regards,
Arivu

8

same error “Column ‘Importes’ does not belong to table”

9

Hi @Braki,

i am getting output correctly can you check again

output
output1364×732 43.7 KB
for each.xaml (9.9 KB)
Libro1.xlsx (227.5 KB)

Regards,
Arivu

1 Like
10

Hi
It worked correctly !

Thank you very much for the help

11

U r welcome @Braki

Regards,
Arivu