Search: select-item-1
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 158Activities
- 38akaBot Center
- 10Data Service
- 9akaBot Agent
- 7akaBot Studio
- … 8 more
Last author
- 88admin
- 41Nga Nguyen
- 25VuNH54
- 24Tuan Nguyen
- 21Nhan Nguyen
- … 5 more
Creator
- 157admin
- 29Giang Tran
- 22Nga Nguyen
- 18Tuan Nguyen
- 4DatPT
- … 4 more
Last modification date
Creation date
Object type
Uploaded by
- 63admin
- 57Nga Nguyen
- 41Nhan Nguyen
- 27Giang Tran
- 21Tuan Nguyen
- … 3 more
Upload date
Write Range
Located in
- Rendered document content
) - If you select this, the column headers from the specified spreadsheet range are also extracted. By default, this check box is selected (set to True).
- Raw document content
-20220505135914-1.jpeg]] (* for mandatory) == **In the body of activity** == * **Workbook Path** - The path
…Headers (Checkbox)** - If you select this, the column headers from the specified spreadsheet range are also extracted. By default, this check box is selected (set to True). ))) {{velocity
Excel Application Scope
Located in
- Rendered document content
the macro level for the current Excel file. By default, EnableAll is selected. The drop-down contains three
…Excel Macro settings Read Only (Checkbox): Opens the specified workbook in Read-Only mode. Selecting
…or has an edit password. By default, this check box is not selected. Visible (Checkbox )- When selected
- Raw document content
for Excel Activities. [[image:image-20220505111836-1.jpeg]] (* for mandatory) == **In the body
…)** - Specifies the macro level for the current Excel file. By default, EnableAll is selected. The drop-down
…. Selecting this check box enables you to perform data extraction operations in an Excel file which is locked
Excel Insert Or Delete Columns
Located in
- Rendered document content
) - The number of columns you wish to add or remove. E.g: 1 Position (Int32) - The column where the insertion
…to add or remove. E.g: 1 Position (Int32) - The column where the insertion or removal begins. E.g: 2 Input Change Mode (Dropdown List) - Selects whether the activity adds or removes columns. ・Add: Add
- Raw document content
. [[image:image-20220505141134-1.png]] (* for mandatory) == **In the body of activity** == * **Number of columns (Int32)** - The number of columns you wish to add or remove. E.g: 1 * **Position (Int32
…of column (Int32)** - The number of columns you wish to add or remove. E.g: 1 * **Position (Int32
Execute Query
Located in
- Rendered document content
to be executed. This field must be completed according to the selection from the CommandType property. E.g: “SELECT * FROM ContactList” Properties Common Continue On Error (Boolean) - This property specifies
…to be executed. This field must be completed according to the selection from the CommandType property. E.g
- Raw document content
-20220506105340-1.png]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set
…/Database/Activities/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Edit Query** - SQL command to be executed. This field must be completed according
Execute Non Query
Located in
- Rendered document content
affected by the command. For all other types of statements, the return value is -1. (* for Mandatory
…Query - SQL command to be executed. This field must be completed according to the selection from
…to the selection from the CommandType property. E.g: “DELETE * FROM ContactList” Misc Public (Checkbox) - Check
- Raw document content
. For all other types of statements, the return value is -1. [[image:image-20220506105309-1.png
…/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Edit Query** - SQL command to be executed. This field must be completed according to the selection from
Open Application
Located in
- Rendered document content
RCA.Activities.Common.OpenApplication Description The Open Application activity allows you to open an application and execute multiple activities within it. (* is mandatory) In the body of activity Indicate window on screen- Allows you to automatically open an application by selecting its
- Raw document content
and execute multiple activities within it. [[image:image-20230417163220-1.png]] (* is mandatory
…by selecting its window. * **Do** - The activities you want to execute within the application. == **Properties
…to organize and structure your code better. E.g: [3424325] Open Window (% class="wikigeneratedid" id="H-1
Close Window
Located in
- Rendered document content
RCA.Activities.Common.CloseWindow Description The Close Window activity allows you to close an application window on the screen. (* is mandatory) In the body of activity Indicate on screen- Allows you to close which application by selecting its window. Properties Common Continue On Error (Boolean
- Raw document content
on the screen. [[image:image-20230417161136-1.png]] (* is mandatory) == **In the body of activity** == * **Indicate on screen**- Allows you to close which application by selecting its window. == **Properties
Attach Window
Located in
- Rendered document content
RCA.Activities.Common.AttachWindow Description The Attach Window activity allows you to attach to an already opened window and execute activities within the window. (* is mandatory) In the body of activity Indicate window on screen- Allows you to automatically attach an application by selecting its
- Raw document content
window and execute activities within the window. [[image:image-20220505133620-1.png]] (* is mandatory
…an application by selecting its window. * **Do** - The activities you want to execute within the application
Move Window
Located in
- Rendered document content
RCA.Activities.Common.MoveWindow Description The Move Window manipulates the position of the selected window. (* is mandatory) Properties Common Continue On Error (Boolean) - A Boolean variable has two possible values: True or False - True : allows the rest of the process to continue
- Raw document content
(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Common.MoveWindow == **Description** == The Move Window manipulates the position of the selected window. [[image:image-20230417163133-1.png]] (* is mandatory) == **Properties** == **Common** * **Continue On Error
Maximize Window
Located in
- Rendered document content
RCA.Activities.Common.MaximizeWindow Description The Maximize Window activity allows you to select a window and maximizes it. (* is mandatory) Properties Common Continue On Error (Boolean) - A Boolean variable has two possible values: True or False - True : allows the rest of the process
- Raw document content
(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Common.MaximizeWindow == **Description** == The Maximize Window activity allows you to select a window and maximizes it. [[image:image-20230417162535-1.png]] (* is mandatory) == **Properties** == **Common** * **Continue On Error