Search: select-item-1

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

) Properties Input Sheet name (String) - The name of the sheet from which to select the specified range

)* - The range to be selected. Only String variables and strings are supported. E.g: “A1:K10” Misc Public

Excel Select Range

Excel Select Range

" %) ((( RCA.Activities.Excel.ExcelSelectRange == **Description** == The activity allows you to select and execute a specified range from an Excel spreadsheet, in order to perform further actions. [[image:image-20220505133120-1.jpeg

which to select the specified range. By default, this is filled in with "Sheet1". Only String variables

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

” button in the upper right corner. Select the pipeline you want to configure. This opens a pipeline settings screen where you can open the “Fields to capture” tab. In this tab, you can select and deselect

right corner. [[image:image-20220421002856-1.png]] 1. Select the pipeline you want to configure. 1. This opens a pipeline settings screen where you can open the “Fields to capture” tab. 1. In this tab, you can select and deselect fields according to their relevance to the documents you are processing. 1. When you

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

settings. In this tab, you can manage pre-trained data fields and select which of them should be extracted. Adding a new table In order to create a new table, click [Add Field], select Data Type = “table

to Capture tab in the queue settings. In this tab, you can manage pre-trained data fields and select which of them should be extracted. (% style="text-align:center" %) [[image:image-20220421003652-1.png||data

, click [Add Field], select Data Type = “table” and then input the value you want to create a new table

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

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 supported variable is Object. To change the variable type, please select the corresponding options

branches, each one is executed based on a specified condition. [[image:image-20220505162342-1.png

the variable type, please select the corresponding options in TypeArgument property. * **Type Argument

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