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
-
Cell : “A”+(dt1.Rows.Count+1).ToString
-
Value: “Total”
Hope it helps you
Regards
Nived N
Happy Automation
1 Like
Wow!! It worked thank you so much! I really appreciate your help
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.