Search: excel-get-column-name

-package Add Delete Column: Adds blank columns or removes existing columns from a specified sheet. Add

of a Google spreadsheet file. Get Cell Color: Extracts the background color of a cell and saves it as a Color variable Get sheets: Uses the Microsoft Graph Get worksheet API to retrieve and return an array

: === **1.  Sheets sub-package** === (% class="box" %) ((( * Add Delete Column: Adds blank columns or removes existing columns from a specified sheet. * Add Delete Rows: Adds empty rows or removes existing

. * Get Cell Color: Extracts the background color of a cell and saves it as a Color variable * Get sheets

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

by going to Report tab > Select Agent tab. No Column Description 1 Agent Name The name of the Agent

being connected to Center. Here, you can get information such as the number of successful tasks

that was run by the selected Agent or Workflows You can get your reports by Agent and Workflow. To access

-20221101161308-7.png]] |=No|=Column|=Description |1|Agent Name|The name of the Agent which activities

are currently being connected to Center. Here, you can get information such as the number of successful tasks

that was run by the selected Agent or Workflows You can get your reports by **Agent** and **Workflow

Add Data Column Add Data Row Build Data Table Clear Data Table Filter Data Table For Each Row Generate Data Table Get Row Item Join Data Tables Look Up Data Table Merge Data Table Output Data Table Remove Data Column Remove Data Row Remove Duplicated Rows Sort Data Table

* [[Add Data Column>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Add

://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Generate%20Data%20Table/]] * [[Get Row Item>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Get%20Row%20Item/]] * [[Join Data Tables>>url:https

them with a semicolon (“;”). Use Asterisk to get all files. The default value is: All files E.g: Image files (.bmp, .jpg)|.bmp;.jpg| .Excel files (.xlsx)|.xlsx Misc Public (Checkbox) - If you

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

multiple file types, separate them with a semicolon (“;”). Use Asterisk to get all files. The default value is: All files E.g: Image files (.bmp, .jpg)|.bmp;.jpg| .Excel files (.xlsx)|.xlsx **Misc

, consider data security before using it. * **Display Name (String) **- The name of this activity. You can

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