Search: select-file

base, generating the PDF files, sending emails… This document aims to guide you how to use the akaBot

allows you to easily access to specific functionalities as below: # Panel Description 1 File Display the functionalities which you can use to operate on the file. 2 Home Display the functionalities which you can use

on web, on desktop, working with data base, generating the PDF files, sending emails… This document aims

: |=#|=Panel|=Description |1|File|Display the functionalities which you can use to operate on the file. |2|Home

:16px" %)**I. File Panel**(%%) ==== To access the File panel, click File at the top left corner

: Enters a text or a formula in a cell. The activity can be used with an Excel file selected for a parent

workbook. If no other workbook is specified, it is copied to the source file. Delete Range: Uses

of a Google spreadsheet file. Get Cell Color: Extracts the background color of a cell and saves it as a Color

Cell: Enters a text or a formula in a cell. The activity can be used with an Excel file selected

to the source file. * Delete Range: Uses the Microsoft Graph Clear range (when **Shift** is //None//) or Delete

from the specified spreadsheet. * Download spreadsheet: Download a copy of a Google spreadsheet file

) In the body of activity Workbook Path - The path of the Excel file you want to write to. E.g: “C:\FolderName

Workbook Path (String)* - The path of the Excel file you want to write to. E.g: “C:\FolderName

) - If you select this, the column headers from the specified spreadsheet range are also extracted

of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The name

Path (String)*** - The path of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx

Headers (Checkbox)** - If you select this, the column headers from the specified spreadsheet range

) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C

, this is filled in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g

] Read Column Options Preserve Format (Boolean) - Selecting this check box keeps the formatting

]] (* for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file

" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName

] Read Column **Options** * **Preserve Format (Boolean) **- Selecting this check box keeps

the macro level for the current Excel file. By default, EnableAll is selected. The drop-down contains three

Workbook Path (String) - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx” “Do” - The activities you want to execute within the application. Properties File Edit password

)** - 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

)**- When selected, the Excel file is opened in the foreground while performing actions on it. When

of activity Indicate window on screen- Allows you to automatically open an application by selecting its

be passed to the application at startup. You can use this property to open a specific file with the application you want to open. Only one of two fields [File Name] or [Arguments] must be specified. E.g: C

by selecting its window. * **Do** - The activities you want to execute within the application. == **Properties

this property to open a specific file with the application you want to open. Only one of two fields [File Name] or [Arguments] must be specified. E.g: C:\Users\currentuser\Documents\Sample.xlsx * **File Name (String

on a browser to select the item. This activity will generate a string variable (Selector) to specify

Exists (Boolean) - Check if the element exists in the file. Boolean supported only.

target element*** - Chooses the field on a browser to select the item. This activity will generate

** * **Exists (Boolean)** - Check if the element exists in the file. Boolean supported only. ))) {{velocity

, RIGHTDOUBLECLICK.) used when simulating the click event. By default, LEFTCLICK is selected. From (JavaElement) - The file you get the element from Input Element(JavaElement)* - The element you want to get. If [Selector

of the cursor position according to the option selected in the Position field. OffsetY (Int32) - Vertical

, RIGHTDOUBLECLICK.) used when simulating the click event. By default, LEFTCLICK is selected. * **From (JavaElement)** - The file you get the element from * **Input Element(JavaElement)* **- The element you want to get

displacement of the cursor position according to the option selected in the Position field. * **OffsetY (Int32

[])* - Execution of multiple actions from a Java element. Eg: Available actions page-up , page-down, select-all … From (JavaElement) - The file you get the element from. Input Element (JavaElement)* - The element you

a Java element. Eg: Available actions page-up , page-down, select-all … * **From (JavaElement)** - The file you get the element from. * **Input Element (JavaElement)*** - The element you want to get

RCA.Activities.Java.GetText Description This activity allows you to get text from a Java file. (* is mandatory) In the body of the activity Pick target element - Chooses the field to select the item

(JavaElement)* - The element you want to get. From (JavaElement) - The file you get the element from Selector

" %) ((( RCA.Activities.Java.GetText == **Description** == This activity allows you to get text from a Java file

** * **Pick target element** - Chooses the field to select the item. This activity will generate a string

)* **- The element you want to get. * **From (JavaElement)** - The file you get the element from * **Selector