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
- 151Activities
- 31akaBot Center
- 7akaBot Agent
- 7akaBot Studio
- 7akaBot Vision
- … 10 more
Last author
- 88admin
- 32Nhan Nguyen
- 30VuNH54
- 21Giang Tran
- 17Nga Nguyen
- … 5 more
Creator
- 152admin
- 45Giang Tran
- 7Tuan Nguyen
- 5JP Comtor
- 4Nga Nguyen
- … 4 more
Last modification date
Creation date
Object type
File type
Uploaded by
- 59admin
- 47Giang Tran
- 46Nhan Nguyen
- 24Nga Nguyen
- 9Tuan Nguyen
- … 3 more
Upload date
[5] Queue
Located in
- Rendered document content
the Queues are located. No Column Description 1 Action Available actions to manage the Queue. Includes
…Queue in display and allow you to bulk delete selected ones. 2 Name Mandatory. The name of the queue. 3 Description Mandatory. The description of the queue. 4 In progress The item was processed with the Get
- Raw document content
of the queue as below: [[image:image-20221101110211-10.png]] |=No|=Column|=Description |1|Name|The name
…]] |=No|=Column|=Description |1|Action|Available actions to manage the Queue. Includes: Edit: allows you to edit
…delete selected ones. |2|Name|Mandatory. The name of the queue. |3|Description|Mandatory. The description
For Business User
Located in
- Rendered document content
bot in the column named Status. Column label Description Status The current status of the Agent
…) S1: To access Asset page, click Asset in the left menu S2: Find name of asset you want to edit
…in the Action column Option 2: Alternatively, when you click the “eye” icon, details page of asset
- Raw document content
-20230425140027-4.png]] S2: You can check status of any bot in the column named Status. |**Column label
…**in the left menu S2: Find name of asset you want to edit, or quickly search by the **Search **tab on the top
…in the Action column [[image:image-20230425134819-3.png]] **//Option 2~://** Alternatively, when you click
Excel Select Range
Located in
- Rendered document content
a specified range from an Excel spreadsheet, in order to perform further actions. (* for mandatory) Properties Input Sheet name (String) - The name of the sheet from which to select the specified range
…it. Display Name (String) - The name of this activity. You can edit the name of the activity to organize
- Title
Excel Select Range
- Location
Excel Activities
…Excel Select Range
- Raw document content
an Excel spreadsheet, in order to perform further actions. [[image:image-20220505133120-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Sheet name (String) **- The name of the sheet from
…it. Remember to consider data security requirement before using it. * **Display Name (String)** - The name
[3] Queues
Located in
- Rendered document content
: Widget Name Widget Type Description Number of task Input Displays a cumulative total of all
…by Date Column Chart The total number of task per day, with a breakdown by Successful and Failed status. Weekly Exception Breakdown Column Chart Total number of exceptions for each week
- Raw document content
be edited: |=((( Widget Name )))|=((( Widget Type )))|=((( Description ))) |((( **Number of task
…** * **Failed** ))) |((( **Task by Date** )))|((( Column Chart )))|((( The total number of task per day, with a breakdown by **Successful** and **Failed** status. ))) |((( **Weekly Exception Breakdown** )))|((( Column
Read CSV File
Located in
- Rendered document content
Column Names (Checkbox)- Specifies if the first row in the CSV file should be considered a header row. If unselected, the output DataTable will have columns with default names. By default, it is selected. Output
…of this activity will be shown in the log. Be careful, consider data security before using it. Display Name (String
- Raw document content
” * **Include Column Names (Checkbox)**- Specifies if the first row in the CSV file should be considered a header row. If unselected, the output DataTable will have columns with default names. By default
…. Be careful, consider data security before using it. * **Display Name (String) **- The name of this activity
Insert Record
Located in
- Rendered document content
the value 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, the values
…may use an optional Reference string. Its value is returned in the Reference column of the Result
- Raw document content
" %) **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, the values of variables
…** column of the Result property of the Composite Request. Only strings and String variables supported
Excel Remove Duplicates Range
Located in
- Rendered document content
that are duplicated in a specified range. (*for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Range (String
…) - The range from which you want to remove duplicate rows. E.g: "A1:H5" Sheet name (String)* - The name
- Title
Excel Remove Duplicates Range
- Location
Excel Activities
…Excel Remove Duplicates Range
- Raw document content
name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1
…. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet in the workbook where the change must
…. Remember to consider data security requirement before using this property. * **Display Name (String
[1] Create New Learning Model
Located in
- Rendered document content
"Label" and map it to the column name Step 9: Click "Train Instance" button to start training model
…Name, Base Model (optional) and Description (optional) Step 4: Create fields for models If staff choose base model, this new model will get all the fields that the based model has and staff can add more
- Raw document content
" and map it to the column name [[image:image-20221027162613-3.png||cursorshover="true"]] (% class="box
…-20230213140708-2.png||cursorshover="true"]] (% class="box infomessage" %) ((( **Step 3**: Input Model Name, Base
…, this new model will get all the fields that the based model has and staff can add more fields by clicking
Export Chart
Located in
- Rendered document content
or graphs from a specified Excel file as images. (* for mandatory) Properties Input Image Format
…: Png, Bmp and Jpg. Name Contains (String)* - The name of the chart. E.g: “Chart sale” Path to Save (String)* - Directory to save file. E.g: “C:\DestinationSaveFolderName\” Sheet Name (String) - The name
- Location
Excel Activities
- Raw document content
Excel file as images. (% class="wikigeneratedid" id="H" %) [[image:image-20220505134428-1.jpeg
…. * **Name Contains (String)*** - The name of the chart. E.g: “Chart sale” * **Path to Save (String)* **- Directory to save file. E.g: “C:\DestinationSaveFolderName\” * **Sheet Name (String)** - The name
Excel Set Range Color
Located in
- Rendered document content
of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope activity. (* for mandatory) Properties Input Sheet name (String)* - The name of the sheet that contains the cell you want to color. E.g: “Name of the sheet” Range (String)* - The range of data
- Title
Excel Set Range Color
- Location
Excel Activities
…Excel Set Range Color
- Raw document content
using a Color variable. Can only be used within the Excel Application Scope activity. [[image:image-20220505133337-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Sheet name (String)* **- The name of the sheet that contains the cell you want to color. E.g: “Name of the sheet” * **Range