Search: select-item-1

by performing below steps: Step 1: In Settings screen ( if in the List Workflows screen then select Settings

to show hidden icons. – Right click akaBot icon. – Select Show akaBot Agent. After that, akaBot Agent

Configuration form. If select No proxy or Auto detect option, go to step 3. If select Manual proxy option, you

. **Step 1:** – In Settings screen ( if in the List Workflows screen then select Settings button

akaBot Agent** == To operate a bot, you need to follow below actions: 1. Configure network setting to open connection to the akaBot Center if needed. 1. Configure bot setting & connect to akaBot Center. 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

of activity Entry* – Area where you add entry activity for the selected state. Exit* - Area where you add exit activity for the selected state. Transition* - Area where you display all the transitions linked to the selected state. Properties Misc Display Name (String) - The name of this activity. You can edit the name

, exits and transitions. Double click to add activities. [[image:image-20220506144248-1.png

for the selected state. * **Exit*** - Area where you add exit activity for the selected state. * **Transition* **- Area where you display all the transitions linked to the selected state. == **Properties

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

System.Activities.Statements.State Description This activity is used when you finish and you want to end the execution. (* for Mandatory) In the body of activity Entry* – Area where you add entry activity for the selected state. Properties Misc Display Name (String) - The name of this activity. You

. [[image:image-20220506144216-1.png]] (* for Mandatory) == **In the body of activity** == * **Entry*** – Area where you add entry activity for the selected state. == **Properties** == **Misc** * **Display Name

] 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