Search: select-item-1

RCA.Activities.Excel.ExcelSelectSheet Description The activity allows you to select and execute

(String)* - The name of the sheet from which to select the specified range. By default, this is filled

. E.g: Select Sheet

Excel Select Sheet

Excel Select Sheet

" %) ((( RCA.Activities.Excel.ExcelSelectSheet == **Description** == The activity allows you to select and execute a specified sheet, in order to perform further actions. [[image:image-20220505132753-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Sheet name (String)* **- The name of the sheet from which to select

to be read. If there is no amendment, “Sheet1” is automatically selected. “Cell” - Specified cell need has to identify to read. If there is no amendment, “A1” is automatically selected. Properties Input Cell

) - Selecting this check box keeps the formatting of the cell that you want to read. By default, the check box

it in a variable. It is only be used inside the Excel Application Scope activity. [[image:image-20220505112903-1

selected. * **“Cell” **- Specified cell need has to identify to read. If there is no amendment, “A1” is automatically selected. == **Properties** == **Input** * **Cell (String)*** - The cell that you want

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

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 Lookup Range Option Look in (Dropdown List) - Select type of value to look up into range that has been selected: Formulas, Values, Comments Output Result (String) - The cell where the specified

with a certain value and returns them as String variables. [[image:image-20220505142148-1.png

. E.g: [759682936] Excel Lookup Range **Option** * **Look in (Dropdown List) **- Select type of value to look up into range that has been selected: Formulas, Values, Comments **Output

Options Add Headers - 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). Preserve Format - Keeps

. This activity uses ClosedXML library [[image:image-20220505135434-1.jpeg]] (* for mandatory

. E.g: Read Range **Options** * **Add Headers **- 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

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

-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

) - The key you want to use to reactivate the mouse and keyboard. You can select this in the body of the activity. KeyModifiers (Dropdown list) - The modifiers you want to use alongside the key selected

[1] Core Activities

to designate a hotkey combination to re-enable them. [[image:image-20220505100618-1.jpeg

and keyboard. You can select this in the body of the activity. * **KeyModifiers (Dropdown list)** - The modifiers you want to use alongside the key selected in the Key property to reactivate the mouse

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

[1] Core Activities

directory. [[image:image-20220513104343-1.png]] (* for Mandatory) == **Properties** == **Input

” * **Search Option **(Drop down 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

RCA.Activities.Excel.ExcelExportChart Description This activity allows you to export charts or graphs from a specified Excel file as images. (* for mandatory) Properties Input Image Format (DropDownList)* - Select the file type that you want to save the exported chart/graph as. It contains 3 types

Excel file as images. (% class="wikigeneratedid" id="H" %) [[image:image-20220505134428-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Image Format (DropDownList)* **- Select the file

can edit the name of the activity to organize and structure your code better. E.g: [351576757] Select

[1] Core Activities

[[image:image-20220513103534-1.png]] (* for Mandatory) == **Properties** == **Common

edit the name of the activity to organize and structure your code better. E.g: [351576757] Select