Append Column with word

Hi All,

I am reading excel file as :

and need to write the same in excel with first column appended like-

Any help or xaml will be really helpful.

Easiest way is to read the excel sheet, use a for loop and Use a Write cell in that loop with value "Test-Data:" + row(0).toString.

Attached a sample reference file. Append_Column_Example.xaml (9.3 KB)


  1. use Read Range Activity to read the data from Excel file and will give you output as dataTable and say ‘DT’.

  2. And then use For Each Row Activity to itreate that dataTable.

               ForEach row in DT
                     Assign, row("Id") = "Test-Data:"+row("Id").Tostring
               End loop

Use Write Range Activity to write into Excel file and pass dataTable ‘DT’ to it.

1 Like

@rachrahul2 : Thanks a lot. Its working fine.

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