Need to add value 1 to one more coloumn

Help
1

Hi,

I have a column with values
Input
0
1
2
3
4

I need to add one more column to same excel by adding 1 to the first column

output
1
2
3
4

1 Like
2

In the excel application scope, use read range and store the data in data table @Karthik_Kulkarni

then, use for each row and loop through each row

  1. within that, use assign activity to get value of each row, you will get the index of the row as well in the properties of for each row activity
  2. Then, use write cell activity to write the value to the next column (assume “B”), providing the dynamic range as “B” + outputrange.tostring
1 Like
3

Hi
here you go with the sample xaml
hope its resolved
datacolumn.zip (15.8 KB)

Cheers @Karthik_Kulkarni

4

Hi @Palaniyappan,

Actually in sheet my input is like below
image 0

so at the place 5 it is coming again as 0 could you please tell me y?