Search: select-item-1

, Add activity # Item Description More Details 1 New Create new sequence, flowchart, State Machine

of a selected activity. Step 1: Double click an activity in Designer panel. Properties of that activity

allows you to easily access to specific functionalities as below: # Panel Description 1 File Display

, Add activity [[image:image-20220506163802-19.png]] |=#|=Item|=Description|=More Details |1|New

and enables you to view and change the properties of a selected activity. * Step 1: Double click an activity

process. [[image:image-20220506161325-1.png]] === **akaBot Studio User Interface** === akaBot Studio

or removal begins. By default, this is filled in with 1. E.g: 2 Input Change Mode (Dropdown List) - Selects

) - The number of rows you wish to add or remove. E.g: 1 Position (Int32) - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 Sheet name (String)* - The name of the sheet

, this is filled in with 1. E.g: 2 **Input** * **Change Mode (Dropdown List) **- Selects whether

. [[image:image-20220505140814-1.png]] (* for mandatory) == **In the body of activity** == * **Number of row (Int32)** - The number of rows you wish to add or remove. E.g: 1 * **Position (Int32

) - The number of columns you wish to add or remove. E.g: 1 Position (Int32) - The column where the insertion

to add or remove. E.g: 1 Position (Int32) - The column where the insertion or removal begins. E.g: 2 Input Change Mode (Dropdown List) - Selects whether the activity adds or removes columns. ・Add: Add

. [[image:image-20220505141134-1.png]] (* for mandatory) == **In the body of activity** == * **Number of columns (Int32)** - The number of columns you wish to add or remove. E.g: 1 * **Position (Int32

of column (Int32)** - The number of columns you wish to add or remove. E.g: 1 * **Position (Int32

Copy Items (Dropdown checkboxes) - A dropdown specifying what additional data to copy for the specified range. You can select between Value, Formula, Number Format, Cell Format and All.

or to a different workbook. [[image:image-20220505131502-1.jpeg]] (* for mandatory) == **Properties** == **Copy

and structure your code better. E.g: Copy Range **Options** * **Copy Items (Dropdown checkboxes)** - A dropdown specifying what additional data to copy for the specified range. You can select between Value

RCA.Activities.Core.SelectFolder Description This activity opens a dialog, allows you to select a folder and returns full path of the selected folder. Properties Misc Public (Checkbox) - If you

to organize and structure your code better. E.g: [351576757] Select Folder Output Selected Folder (String

Select Folder

[1] Core Activities

Select Folder

" %) RCA.Activities.Core.SelectFolder == **Description** == This activity opens a dialog, allows you to select a folder and returns full path of the selected folder. [[image:image-20220505093358-1.jpeg]] == **Properties** == **Misc

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

RCA.Activities.Core.SelectFile Description This activity opens a dialog, allows you to select 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

Select File

[1] Core Activities

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

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

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

] 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