Search: excel-get-column-name

RCA.Activities.Salesforce.FormatColumnNames This activity replaces the column names within a designated DataTable variable. Properties Input Data: Specifies the DataTable variable whose column names

a DataTable variable containing two columns: ColumnName: Represents the expected column names present

Format Column Names

Format Column Name

RCA.Activities.Salesforce.FormatColumnNames This activity replaces the column names within

column names need replacement. Only DataTable variables are supported in this field. * **Mapping

column names present in the DataTable variable specified in the Data field. ** **FieldName: **Specifies

-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

Composite Request Insert Record Update Record Delete Record Get Record Get List View Records Upset Record Create Bulk API Job Get Bulk API Job Start or Abort Bulk API Job Get Bulk API Job Result Upload File Download File Assign File Salesforce Application Scope Execute SOQL Execute Report Format Column

/Salesforce/Activities/Execute%20Report/]] * [[Format Column Names>>https://docs.akabot.com/bin/view

%20Record/]] * [[Get Record>>https://docs.akabot.com/bin/view/Activities/Salesforce/Activities/Get%20Record/]] * [[Get List View Records>>https://docs.akabot.com/bin/view/Activities/Salesforce/Activities/Get%20List

Record Delete Record Get Record Get List View Records Upset Record Create Bulk API Job Get Bulk API Job Start or Abort Bulk API Job Get Bulk API Job Result Upload File Download File Assign File Salesforce Application Scope Execute SOQL Execute Report Format Column Names Format Labels and Values Lightning REST API

* Format Column Names * Format Labels and Values * Lightning REST API Request * Search ))) ))) {{velocity

* Insert Record * Update Record * Delete Record * Get Record * Get List View Records * Upset Record * Create Bulk API Job * Get Bulk API Job * Start or Abort Bulk API Job * Get Bulk API Job Result * Upload

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

: The column name must be valid in the Salesforce object you want to insert. Misc DisplayName - The display name of the activity. Public - If selected, the values of variables and arguments will be logged

Get Record RCA.Activities.Salesforce.GetRecord You may use this activity to retrieve a record

Get Record

Get Record

specified in this field. **Note**: The column name must be valid in the Salesforce object you want to insert. **Misc** * **DisplayName** - The display name of the activity. * **Public** - If selected

**Get Record** RCA.Activities.Salesforce.GetRecord You may use this activity to retrieve a record