Search: excel-get-column-name

is to be retrieved from the DataRow. Eg: 11 Column Name (String)* - The name of the column whose value

and structure your code better. Eg: Get row item Output Value - The column value from the specified DataRow.

RCA.Activities.Core.GetRowItem Description This activity allows you to get a value from

Get Row Item

get row item.jpg

Get Row Item

is to be retrieved from the DataRow. Eg: 11 * **Column Name (String)*** - The name of the column whose value

" %) ((( RCA.Activities.Core.GetRowItem == **Description** == This activity allows you to get a value from a DataRow variable according to a specified column. [[[[image:get row item.jpg]]>>attach:get row item.jpg

the structured text. This activity enables you to select column and row separators according to which the table

(default) - blocks the process from continuing the execution. Fixed formatting options Column Sizes (IEnumerable< Int32 >) - Specifies the size of the columns that are to be created in the table. This field

. This activity enables you to select column and row separators according to which the table is generated

) - blocks the process from continuing the execution. **Fixed formatting options** * **Column Sizes (IEnumerable< Int32 >)** - Specifies the size of the columns that are to be created in the table. This field

from the column collection of the DataTable. Eg: 12. Column Name (String)* - The name of the column

Column to a specified DataTable. (* is mandatory) Properties Input Column (DataColumn)* - A DataColumn object to be removed from the column collection of the DataTable. If this property is set

Remove Data Column

remove data column.jpg

Remove Data Column

of the DataTable. Eg: 12. * **Column Name (String)*** - The name of the column to be removed from the column

edit the name of the activity to organize and structure your code better. Eg: “Remove Data Column

" %) ((( RCA.Activities.Core.RemoveDataColumn == **Description** == This activity allows you to remove a Data Column to a specified

only Int32 variables. Eg: 1 Column Name (String) - The name of the column you want to search for. This field supports only strings and String variables. Eg: “Name of column” Data Column (DataColumn

: 1 Column Name (String) - Specifying a Column name here returns the value of the cell found

supports only Int32 variables. Eg: 1 * **Column Name (String)** - The name of the column you want to search for. This field supports only strings and String variables. Eg: “Name of column” * **Data Column

and the value from the RowIndex property. This field supports only Int32 variables. Eg: 1 * **Column Name

to a specified DataTable. (* is mandatory) Properties Input Column (DataColumn)* - A DataColumn object that is to be appended to the column collection of the DataTable. Column Name (String)* - The name of the new column you

)* - The DataTable object in which you want to add a column. This field supports only DataTable objects. Misc

Add Data Column

add data column.jpg

Add Data Column

** == **Input** * **Column (DataColumn)*** - A DataColumn object that is to be appended to the column collection of the DataTable. * **Column Name (String)*** - The name of the new column you want to add

in which you want to add a column. This field supports only DataTable objects. **Misc** * **Public

) - The index of the column you want to sort. Eg: 3 Column Name (String) - Name of the sorting column. Eg: “Column name here”. Data Column (DataColumn) - The variable containing the column you want to sort

in ascending or descending order, based on the values of a specified column. (* is mandatory) Properties

) **- The index of the column you want to sort. Eg: 3 * **Column Name (String)** - Name of the sorting column. Eg: “Column name here”. * **Data Column (DataColumn)** - The variable containing the column you want to sort

order, based on the values of a specified column. [[[[image:sort data table.jpg||class="img-thumbnail

Table with different settings. In the body of activity Data Table - Click to add/ remove columns, update column name/ column type Properties Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements before using it. Display Name (String) - The name

]] == **In the body of activity** == **Data Table **- Click to add/ remove columns, update column name/ column type

using it. * **Display Name (String) **- The name of this activity. You can edit the name of the activity

or columns according to the logical conditions that are specified in the wizard. The body of the activity

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

to consider data security requirements before using it. Display Name (String) - The name of this activity. You

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

of activity** == **Filter Wizard **- Set filter for rows, set output columns [[image:image-20230419143358-1

before using it. * **Display Name (String)** - The name of this activity. You can edit the name

to be added to the DataTable. The type of each object should map to the type of its corresponding column

a column. This field supports only DataTable objects. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements before using it. Display Name (String

should map to the type of its corresponding column in the DataTable. * **Data row (DataRow

is ignored. * **Data Table (DataTable)*** - The DataTable object in which you want to add a column

to publicize it. Remember to consider data security requirements before using it. * **Display Name (String

to consider data security requirements before using it. Display Name (String) - The name of this activity. You can edit the name of the activity to organize and structure your code better. Eg: Remove Duplicated Rows. Output Output Data Table(DataTable) - The column value from the specified DataRow.

using it. * **Display Name (String) **- The name of this activity. You can edit the name

** * **Output Data Table(DataTable) **- The column value from the specified DataRow. ))) {{velocity