Issue with the sum in excel


#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


How to convert a table to pivot table with sum of a particular column
#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

for each.xaml (9.9 KB)
Libro1.xlsx (227.5 KB)

Regards,
Arivu


#10

Hi
It worked correctly !

Thank you very much for the help


#11

U r welcome @Braki

Regards,
Arivu