Append Column with word

[Zahid1 (Zahid)]

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.

[rachrahul2 (Rahul Rachamalla)]

Hey,
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)

[lakshman (Ganta lakshman)]

@Zahid1

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.

[Zahid1 (Zahid)]

@rachrahul2 : Thanks a lot. Its working fine.