How to write the same value to all rows to particular range… With out write cell… as it takes a long time
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.
idk if its safe, but one way without looping
I get the error as A column named ‘XYZ’ already belongs to this DataTable.
How can I add same column value to multiple rows?