In Existing excel file in have 3 columns (web scraped) and i have to update column 4 a string based on 3 rows, how to do it in loop

Help
1

Excel 1(Existing)
C1 c2 c3
AA BB CC
A1 B2 C3

Below values need to be updated in C4 (column 4)
C4
DD
D4

3

Hi,

Could you be more specific and if possible provide the input file.

4

Hi @Balakn,

try with Write cell activity

image

5

Hi,
Can you try putting the Column 4 values in a array and then add those to the data table by creating new column using add data column activity. assign the array values to the column row.item(columnname)=arrayVariable(index) where index is a local variable which should increment for each row

Find the attached file for clear understanding

If this helps please mark the solution.ExcelAddColumn.zip (16.2 KB)

2 Likes