I receive mail on outlook and in Each Mail Contains only one Excel Attachment,
That attachment contains only one Row and Have to process Something in One Sequence.
In this I want to add Status column and, in Each run, have to update Status in Each transaction. (Successful/ Unsuccessful).
=> Use the Use excel file activity and give the path of the excel file.
=> Inside use excel file insert the Insert column activity to insert the new column called status.
=> After Insert column activity insert the for each excel row activity to iterate the each row in the excel.
=> Inside for each excel row insert the Write cell activity to update the status column.