Search: select-file

a file and returns full path of the selected file. Properties Input Filter (String) – Used to specify the type of file you want to select. This filter should contain a description of the filter and followed by a vertical bar (|) and the filter pattern. If you want to select multiple file types, separate

Select File

Select File

" %) ((( RCA.Activities.Core.SelectFile == **Description** == This activity opens a dialog, allows you to select a file and returns full path of the selected file. [[image:image-20220505093334-1.jpeg]] == **Properties** == **Input** * **Filter (String) **– Used to specify the type of file you want to select. This filter should contain

to organize and structure your code better. E.g: [011594913] Select File

] Select File ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc" %) ((( (% class="akb

a specified file and store it in a String variable. (* for Mandatory) In the body of activity File name (String)* - The path of the file. If the path is not full, the file is created in the project folder. E.g: "C:\Users\Admin\Desktop\inputfile.xlsx" or “inputfile.xlsx” Properties File Encoding (String

Read Text File

Read Text File

Marks are detected, the UTF-8 encoding is selected by default. * **File Name (String)* **- The path

" %) ((( RCA.Activities.Core.ReadTextFile == **Description** == This activity allows you to read all characters from a specified file

) == **In the body of activity** == * **File name (String)*** - The path of the file. If the path is not full

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

are detected, the UTF-8 encoding is selected by default. File Name (String)* - The path of the file. Write

text into a file. If the file already exists, the pre-existing text is overwritten. If the file does not exist, it is created. (* for Mandatory) In the body of activity File name (String)* - The path

Write Text File

Write Text File

. Core.Activities.WriteTextFile == **Description** == This activity allows you to write the specified text into a file. If the file already exists, the pre-existing text is overwritten. If the file does not exist, it is created. [[image:image-20220513111351-1.png]] (* for Mandatory) == **In the body of activity** == * **File name

Marks are detected, the UTF-8 encoding is selected by default. File Name (String)* - The path

string to a file, creating the file if it does not already exist. (* for Mandatory) In the body of activity File name (String)* - The path of the file to append the line to, if the file is not created

" %) ((( RCA.Core.Activities.AppendLine == **Description** == This activity allows you to append the specified string to a file, creating the file if it does not already exist. [[image:image-20220513103343-1.png]] (* for Mandatory) == **In the body of activity** == * **File name (String)*** - The path of the file to append the line

: 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

list)- Drop down with 2 search options. Select Top Directory if you want to search for the files in the current folder only or select AllDirectories if you want to search for the files in the sub-folder

RCA.Activities.Core.GetFiles Description This activity allows you to return the names of files

Get Files

to search for the files in the current folder only or select AllDirectories if you want to search

== **Description** == This activity allows you to return the names of files (including their paths) in a specified

** * **Creation Time (From) (DateTime)** – Looks for files create from this date onward. Left blank if the created

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

) 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