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

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

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

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

[1] Core Activities

[[image:image-20220513103534-1.png]] (* for Mandatory) == **Properties** == **Common

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

. E.g: [351576757] Select Folder Options Overwrite (Checkbox) - Check this option to overwrite

[1] Core Activities

to another. [[image:image-20220513103651-1.png]] (% class="wikigeneratedid" id="H" %) (* for Mandatory

of the activity to organize and structure your code better. E.g: [351576757] Select Folder **Options

. If unselected, the output DataTable will have columns with default names. By default, it is selected. Output

. [[image:image-20220505105117-1.jpeg]] (* is mandatory) == **In the body of activity** == * **File

, it is selected. **Output** * **Data Table (DataTable)** - Represents the output DataTable that contains