Articles → UiPath → Insert/Update Columns And Insert/Update Rows Activities In Uipath

Insert/Update Columns And Insert/Update Rows Activities In Uipath

In this article, we will discuss the "Insert/Update Columns" and "Insert/Update Rows" activities in UiPath.

Insert/Update Columns

This activity inserts or deletes the column in the Excel sheet. In the "Insert/Update Columns" activity, there is an attribute called "ChangeMode".

This attribute specifies whether you should perform the add operation or remove operation.

Click to Enlarge

In this example, we will add 2 "Insert/Update Columns" activities (one for adding a column and the other for deleting the column).

Picture showing the 2 Insert/Update Columns activities in the designer screen

Click to Enlarge

Here is the output

Picture showing the output of Insert/Update Columns activity in UiPath

Click to Enlarge

Insert/Update Rows

This activity adds or removes the rows in the Excel sheet. Let us work on the example.

Click to Enlarge

Here is the output

Picture showing the output of Insert/Update Rows activity in UiPath

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Friday, January 15, 2021

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**