I want to replace the last row with value zero with a word 'Total'


In the last row of column ID, instead of zero I want to write “Total” and make it dynamic

Use write cell activitiy for writing there

If the rows are dynamic , then first ur read range and store in dt1

Then use write cell activitiy with property as

If ID is in ‘A’ column

  1. Cell : “A”+(dt1.Rows.Count+1).ToString

  2. Value: “Total”

Hope it helps you


Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed::relaxed:

1 Like

Wow!! It worked :smiling_face_with_three_hearts: thank you so much! I really appreciate your help :slight_smile:

1 Like

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