Search: select-item-1

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

message when user does not select value in [Copy Items]. [ExcelCopySheet] Screen hangs when typing

[1] Release Notes

Password. * [ExcelCopyPasteRange] Modify message when user does not select value in [Copy Items

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

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

] 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