Replace data in excel with existing data

[Aditya10989 (aditya)]

In excel sheet one column must contain 8 digit if less then this then add zero zero before
eg 123456 replace with 00123456
I have done this no

w I am replacing with existing value how can I achieve this I am using write cell.

[KarthikByggari]

Hi,

Follow these steps to achieve the required output.

1. Read Range Activity to read the entire column. For example if you want to read column A, In the read range set the address to “A:A” . The output will be saved to a datatable.

Default value of Count = 0. If headers are present, set default value of counter to 1.

2. For Each row in DataTable
   Count = Count + 1
   StrValue = row(0).ToString.PadLeft(8, ‘0’)
   Write Cell Activity, set value to StrValue and address to “A” + Count.ToString

Regards,
Karthik Byggari

[Aditya10989 (aditya)]

thanks