Search: excel-get-column-name
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Last author
- 31Nhan Nguyen
- 15admin
- 12Nga Nguyen
- 10VuNH54
- 9Tuan Nguyen
- … 1 more
Last modification date
Creation date
Object type
- 11Activities
- 1Live Table
- 1UI Extension
- 1aka Bot Center
Uploaded by
- 41Nhan Nguyen
- 20Nga Nguyen
- 6admin
- 2Giang Tran
- 2VuNH54
- … 1 more
Upload date
Format Column Names
Located in
- Rendered document content
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
- Title
Format Column Names
- Location
Format Column Name
- Raw document content
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
[1] Release Notes
Located in
- Rendered document content
-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
- Raw document content
: === **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
Get Row Item
Located in
- Rendered document content
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
- Title
Get Row Item
- Attachment name
get row item.jpg
- Location
Get Row Item
- Raw document content
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
Activities
Located in
- Rendered document content
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
- Raw document content
/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
Release Notes
Located in
- Rendered document content
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
- Raw document content
* 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
Generate Data Table
Located in
- Rendered document content
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
- Raw document content
. 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
Activities
Located in
- Rendered document content
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
- Raw document content
* [[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
Select File
Located in
- Rendered document content
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
- Raw document content
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
Get Record
Located in
- Rendered document content
: 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
- Title
Get Record
- Location
Get Record
- Raw document content
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
Remove Data Column
Located in
- Rendered document content
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
- Title
Remove Data Column
- Attachment name
remove data column.jpg
- Location
Remove Data Column
- Raw document content
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