How to Copy paste same value in all rows of same column?

[shrganes (Shruthi Ganesan)]

How to write the same value to all rows to particular range… With out write cell… as it takes a long time

[Santan_Barnwal]

Hi,

You can use “Build Data Table” and “Add Data Row” activity.

Just create a Data Table By using “Build Data Table” and add rows by using “Add Data Row” activity.
After adding all rows, use “Write Range” activity to write values to a particular range.

Thanks.

[vvaidya (Vinay Vaidya)]

idk if its safe, but one way without looping

[rinki (SS)]

Hi @vvaidya,

I get the error as A column named ‘XYZ’ already belongs to this DataTable.
How can I add same column value to multiple rows?