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!
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.