検索：select-item-2

the functionalities which you can use to operate on the file. 2 Home Display the functionalities which you can use

for detailed user guide. 2 Open Open an existed workflow project. Refer to section: 2.2.2 Open a project

should follow below actions: Step 1: Click ‘New’ Step 2: Choose type workflow: Blank or General Business

[2] How to use akaBot Studio

[2] Getting Started

[2] How To Use akaBot Studio

: |=#|=Panel|=Description |1|File|Display the functionalities which you can use to operate on the file. |2|Home

of the screen: The User Interface of File panel is as below: [[image:image-20220506161341-2.png]] The File

workflow project. Refer to section: 2.2.1 Create a new workflow project for detailed user guide. |**2

or removal begins. E.g: 2 Sheet name (String)* - The name of the sheet in the workbook where the change must

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

)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet

)** - 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 columns to the document. **・Delete

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

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

)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet

" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}}

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.

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

="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2

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

” * **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

-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}} )))

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

which to select the specified range. By default, this is filled in with "Sheet1". Only String variables and strings are supported. * **Range (String)*** - The range to be selected. 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

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

. You can edit the name of the activity to organize and structure your code better. E.g: Select Sheet

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

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

and structure your code better. E.g: Read Cell **Options** * **Preserve Format (Checkbox)** - Selecting

] 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

. 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

))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}}

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

]] (* for mandatory) == **Properties** == **Input** * **Image Format (DropDownList)* **- Select the file

-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2