How to assign same row value to all rows

Let’s say i have one Excel, in which i have to update same row value to all rows …?
(Eg: ID column has value Ae98623fg, i have to write this ID value to all rows)

Any idea!

Thanks in advance.


Is this ID column has value in first row only?

There are different ID values in the row, but i have to update same ID value to complete row

U can use
Read Range To read data: Dt
For Each Row for Dt
Use Assign
Row(“ID”)=“Value Which u want to add”

After for each row
Use Write Range

1 Like

You can use write cell activity.
The range can be from the first cell of the column to the last cell of the column.
You just have to get the last cell id.
And the value is the cell value you got.


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