UiPath Excel - set value for the entire excel column

Can anyone please help me on below scenario,

I need to assign value to the entire column without using FOR EACH Activity.

Take Add data Column activity.
Click on property.
In default value you can pass your value , it will add it in your column.
refer the link for other property : https://activities.uipath.com/docs/add-data-column

1 Like


You can use add data row activity and in the property field provide the values in this format {“anil”,“1”}.

1 Like

Hi @Rama_Devi

You can do it as shown in the screenshot…

  1. Add Data Column activity to add the column
  2. For Each row activity to loop through the data table
  3. Assign activity to assign the value to the new column


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