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

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