Want to add one column in Excel and Update Status (Sucess /Fail) For Each Run

Help Activities
, ,
1

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

image
image1532×741 47.7 KB

How we can solve this ?

2

Hi

Hope the below steps would help you resolve this

  1. Use a READ RANGE Workbook activity and get the output as a datatable named dt
    https://docs.uipath.com/activities/other/latest/productivity/read-range

  2. Now use a ADD DATACOLUMN activity and mention the columnname you want
    https://docs.uipath.com/activities/other/latest/workflow/add-data-column

  3. Then you can update the datatable with status using a assign activity like this

dt.Rows(0)(“Status”) = “your status”

  1. Finally use a WRITE RANGE WORKBOOK activity with ADD HEADERS property enabled and write the datatable back to the Same excel file

https://docs.uipath.com/activities/other/latest/productivity/write-range

Cheers @Ajinya_jorwekar

3

Hi @Ajinya_jorwekar

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

Hope it helps!!

4

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