Apply Sum with Excel

[RpaTest_Pwc (Santiago Leguizamón)]

Hi everyone, i try to make a sum of column, but when i try to use the activity, a error appear and say “The Column name is Invalid”.

I see the topic How to sum all values in a column of an excel/Datatable? but dont know how the others do.

Anyone can give me a example?

Thanks !!!

[rahatadi (Aditya Rahatekar)]

@RpaTest_Pwc

Have you checked headers flag while reading excel?

[RpaTest_Pwc (Santiago Leguizamón)]

Yes, but nothing, i dont know what can it be.

[loginerror (Maciej Kuźmicz)]

Hi @RpaTest_Pwc

Have you checked if your column in Excel has any spaces before or after the actual word Suma?

[RpaTest_Pwc (Santiago Leguizamón)]

Sorry for my ignorance, i put .Trim and now works !

Thank you !

[loginerror (Maciej Kuźmicz)]

The only reason I knew it instantly was because I’ve seen this issue in the past That’s the beauty of sharing knowledge on this forum - it’s a journey to become a better rpa developer.

Don’t be afraid to make mistakes and ask, that’s the best way to learn and we’re here to help