uipath technical infomation for everyone

Insert and delete columns


The Insert/Delete Columns activity (Japanese parallel translation: insertion and deletion of columns) is available from UiPath.Excel.Activities v2.4.6856.17931 (release date: October 9, 2018).

 

Procedure

1. Open Excel in the Excel application scope activity. Place the Insert/Delete Columns activity in it.

 

2. Set the properties of the Insert/Delete Rows activity.

 

Specify whether to insert or delete

Properties Commentary
NoRows Specify the number of columns to insert.
Position Specify the row number to insert the column.
ChangeMode column.
Add: Insert/Remove: Remove
SheetName Specify the target sheet name.

 

Before robot execution

 

After robot execution