Search: select-item-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.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

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

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

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

)** - 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 for editing or has an edit password. By default, this check box is not selected. * **Visible (Checkbox