Sum of the row in dynamically appended data on excel

Hello team,

I am new in the RPA journey, so I kindly ask your support on solving an issue with an Excel file, that I have to report every day.
I need to append the data (which are measurements generated by a .csv file) every day and after the measurements are appended on excel, I have to make the sum of the row. I have managed to perform the append activity, but I am facing problems to make the sum of the row, because the cell that needs to be written the sum is dynamic, not a specific one.

I can not upload the file because of security reasons, but I have uploaded a structure of it.

Thank you in advance and your support would be very appreciated!

Dynamic Cell Sum.xlsx (8.5 KB)

Hi @xhulia.kurteshi ,

You can use below linq.
Let me know if you face any issue.
Instead of write range you can use Append range.
Note: Run it by giving file path to excel activities, first try to run as it as then make changes as per your columns.

SumOfTwoSpecificColumn.xaml (7.3 KB)
SumOfTwoColumns.xlsx (8.9 KB)

Hi @ermanoj3101

Thank you for your support so far, but when I try to use the assign activity as per your suggestion, it says that “Rows” is not a member of ‘Double’.

Do you think is there any other thing that I can do to make it work?

Thanks again!

Is it possible for you to share excel or dummy file ?

Hi @xhulia.kurteshi

Please try below method attached xaml below.

SumOfTwoSpecificColumn.xaml (8.1 KB)

Let me know if it works for you.

Regards

Hello Pravin,

It worked for me.

Thank you both for your support! :slight_smile:

Hi @xhulia.kurteshi

Happy Automation!

Regards

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