Search: remove-data-row

Options Filter Rows Mode - Specifies whether to filter the table by keeping or removing the target rows

variable by specifying conditions in the Filter Wizard window. The activity can keep or delete rows

. (* is mandatory) In the body of activity Filter Wizard - Set filter for rows, set output columns Properties

Filter Data Table

filter data table.jpg

Data Table

Mode** - Specifies whether to filter the table by keeping or removing the target rows. * **Select

conditions in the Filter Wizard window. The activity can keep or delete rows or columns according

button so that you can access the wizard and customize your settings at any time. [[[[image:filter data

RCA.Activities.Excel.ExcelInsertRows Description This activity allows you to add more rows to insert one or more rows in a table, range, or sheet at the specified location. This only can be used

(String)* - The name of the sheet that you want to insert row. E.g: “Employee Name” Number of row (Int

Excel Insert Rows

" %) ((( RCA.Activities.Excel.ExcelInsertRows == **Description** == This activity allows you to add more rows to insert one or more rows

of the activity** == * **Sheet name (String)*** - The name of the sheet that you want to insert row. E.g: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5

for each row in a specified DataTable variable. (* is mandatory) In the body of activity Foreach - Set loop variable name in - Data table to loop Body - Add activities that you want to execute in loop Properties Input Data Table (DataTable)* - The DataColumn object whose value is to be retrieved from

For Each Row

for each row.jpg

Data Table

For Each Row

" %) ((( RCA.Activities.Core.ForEachRow == **Description** == This activity allows you to execute an action once for each row

) == **In the body of activity** == **Foreach** - Set loop variable name **in** - Data table to loop **Body **- Add activities that you want to execute in loop == **Properties** == **Input** * **Data Table