I am currently work on a task where I need to write the email date that bot extracted from the outlook and paste it the relevant excel attachment.
(Assuming that each excel attachment is dependent to the email date)
I have a list of 10 emails date that need to be copied over to 10 excel files respectively.
After the first email date copied over to the first excel attachment, ideally I wish to delete the first row data of the email date, so that it won’t get override to 2nd email attachment.
Noted that we need to input row index - Remove Data Row Activity.
I tried to hardcode the row index as 0, apparently it will only work with 2 excel files, however with more than 2 excel files, I will encounter error : Remove Data Row - dtApprovalDate: There is no row at position 0.
How can we set the row index dynamically that it will always only delete the top row of the data table?