Search: excel-select-range

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

of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope

that contains the cell you want to color. E.g: “Name of the sheet” Range (String)* - The range of data

. E.g: Set Range Color

Excel Set Range Color

Excel Set Range Color

Excel Activities

" %) ((( RCA.Activities.Excel.ExcelSetRangeColor == **Description** == This activity allows changing color of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope activity. [[image:image

)* **- The name of the sheet that contains the cell you want to color. E.g: “Name of the sheet” * **Range

RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range

Options Add Headers - If you select this, the column headers from the specified spreadsheet range

(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data

Read Range

Excel Activities

Read Range

" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store

. 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

) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C

in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C

] Read Row Options Preserve Format (Boolean) - Selecting this check box keeps the formatting of the row

Excel Activities

]] (*for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel

". E.g: "A1" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C

. E.g: [841596479] Read Row **Options** * **Preserve Format (Boolean) **- Selecting this check box

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 Activities

Excel file as images. (% class="wikigeneratedid" id="H" %) [[image:image-20220505134428-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Image Format (DropDownList)* **- Select the file

range. You can select between Value, Formula, Number Format, Cell Format and All.

RCA.Activities.Excel.ExcelCopyPasteRange Description This activity allows to copy a range

, this is filled in with "Sheet1." Only String variables and strings are supported. E.g: “Sheet name” Source Range

Excel Copy Paste Range

Excel Copy Paste Range

Excel Activities

)** - A dropdown specifying what additional data to copy for the specified range. You can select between Value

" %) ((( RCA.Activities.Excel.ExcelCopyPasteRange == **Description** == This activity allows to copy a range or sheet (including values, formulas

: “Sheet name” * **Source Range (String)*** - The range of the data you want to copy. This field supports

RCA.Activities.Excel.ExcelDeleteRange Description This activity allows deleting a specified range in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells

variables and strings are supported. E.g: “Employee Data” Range (String)* - The range you want to delete

Excel Delete Range

Excel Delete Range

Excel Activities

" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook

Data” * **Range (String)* **- The range you want to delete. This field supports only strings

Range **Options** * **ShiftCells (Checkbox) **- If you check it, cell formatting is shifted

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

edit the name of the activity to organize and structure your code better. E.g: [038325762] Excel Insert

Excel Insert Or Delete Rows

Excel Activities

Excel Insert Or Delete Rows

, this is filled in with 1. E.g: 2 **Input** * **Change Mode (Dropdown List) **- Selects whether

. E.g: [038325762] Excel Insert Or Delete Rows **Options** * **CopyOrigin (Dropdown List

to insert one or more rows in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body of the activity Sheet name

) - Number of rows you want to insert in Excel sheet E.g: 5 Row position (Int) - Position where the rows

Excel Insert Rows

Excel Activities

Excel Insert Rows

in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope

: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5

] Excel Lookup Range Option Look in (Dropdown List) - Select type of value to look up into range

RCA.Activities.Excel.ExcelLookUpRange Description Searches in a specified range

. E.g: "Sheet1" Range (String)* - The range where you want to perform the search. E.g: "A1:H5" Value

Excel LookUp Range

Excel LookUp Range

Excel Activities

. 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.ExcelLookUpRange == **Description** == Searches in a specified range for the coordinates of a cell