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
- 129Activities
- 30akaBot Center
- 6akaBot Insights
- 6akaBot Vision
- 5akaBot Agent
- … 10 more
Last author
- 64admin
- 32Nhan Nguyen
- 30VuNH54
- 21Giang Tran
- 17Nga Nguyen
- … 4 more
Creator
- 128admin
- 45Giang Tran
- 7Tuan Nguyen
- 4Nga Nguyen
- 3Nhan Nguyen
- … 3 more
Last modification date
Creation date
Object type
File type
Uploaded by
- 55admin
- 45Nhan Nguyen
- 42Giang Tran
- 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
[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
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
[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
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
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
[4] How to set variable task in a process
Located in
- Rendered document content
in definition session Column 1: Name of variables Column 2: Assign variables with new values b
…After clicking in Create New, page changes into the screen below: Component Description 1 Name of process 2 Tasks in a process (drag and drop these tasks to 4 session), logic condition, start, and end
- Raw document content
session |((( **Column 1: **Name of variables **Column 2:** Assign variables with new values
…: [[image:image-20230312195356-13.png]] |**Component**|**Description** |1|Name of process |2|Tasks in a process