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
Location
- 141Activities
- 30akaBot Center
- 6akaBot Insights
- 6akaBot Vision
- 5akaBot Agent
- … 10 more
Last author
- 76admin
- 32Nhan Nguyen
- 30VuNH54
- 21Giang Tran
- 17Nga Nguyen
- … 4 more
Creator
- 140admin
- 45Giang Tran
- 7Tuan Nguyen
- 4Nga Nguyen
- 3Nhan Nguyen
- … 3 more
Last modification date
Creation date
Object type
File type
Upload date
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
Excel Application Scope
Located in
- Rendered document content
RCA.Activities.Excel.ExcelApplicationScope Description This activity allows to open an Excel workbook and provides a scope for Excel Activities. (* for mandatory) In the body of the activity Workbook Path (String) - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx
- Title
Excel Application Scope
- Location
Excel Activities
…Excel Application Scope
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelApplicationScope == **Description** == This activity allows to open an Excel workbook and provides a scope for Excel Activities. [[image:image-20220505111836-1.jpeg]] (* for mandatory) == **In the body of the activity** == * **Workbook Path (String)** - The path of the Excel file you want to read. E.g: “C
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
Append Range
Located in
- Rendered document content
stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created with the name indicated in the Sheetname field. (* for mandatory) In the body of activity Workbook Path - The full path of the Excel spreadsheet that you want to use. If the Excel file
- Location
Excel Activities
- Raw document content
variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created with the name indicated in the Sheetname field. [[image:image-20220505140101-1.jpeg]] (* for mandatory) == **In the body of activity** == * **Workbook Path ** - The full path of the Excel spreadsheet that you want
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
Look Up Data Table
Located in
- Rendered document content
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
- Raw document content
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
Add Data Column
Located in
- Rendered document content
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
- Title
Add Data Column
- Attachment name
add data column.jpg
- Location
Add Data Column
- Raw document content
** == **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
Excel Save Workbook
Located in
- Rendered document content
to the workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties
…requirement 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. E.g: Excel Save Workbook
- Title
Excel Save Workbook
- Location
Excel Activities
…Excel Save Workbook
- Raw document content
it. Remember to consider data security requirement 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. E.g: Excel
…can be used in Excel Application Scope Activity. [[image:image-20220505134823-1.jpeg
Sort Data Table
Located in
- Rendered document content
) - 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
- Raw document content
) **- 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