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

[Ajinya_jorwekar]

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

How we can solve this ?

[Palaniyappan (Palaniyappan P)]

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”

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

[mkankatala (Mahesh Kankatala)]

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!!