Search: excel-select-range

Excel Select Range

Located in

Last modified by Giang Tran on 2022/05/13 06:26

Rendered document content: a specified range from an Excel spreadsheet, in order to perform further actions. (* for mandatory) 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
Title: Excel Select Range
Location: Excel Select Range
…
Excel Activities
Raw document content: " %) ((( 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

Excel LookUp Range

Located in

Last modified by Giang Tran on 2022/05/13 06:22

Rendered document content: ] 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
Title: Excel LookUp Range
Location: Excel LookUp Range
…
Excel Activities
Raw document content: . 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

Excel Delete Range

Located in

Last modified by Giang Tran on 2022/05/13 04:31

Rendered document content: 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
Title: Excel Delete Range
Location: Excel Delete Range
…
Excel Activities
Raw document content: " %) ((( 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

Excel Select Sheet

Located in

Last modified by Giang Tran on 2022/05/13 06:27

Rendered document content: (String)* - The name of the sheet from which to select the specified range. By default, this is filled
…
RCA.Activities.Excel.ExcelSelectSheet Description The activity allows you to select and execute
…
. E.g: Select Sheet
Title: Excel Select Sheet
Location: Excel Select Sheet
…
Excel Activities
Raw document content: " %) ((( 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 the specified range. By default, this is filled in with "Sheet1." Only String variables and strings

Excel Remove Duplicates Range

Located in

Last modified by Giang Tran on 2022/05/13 06:24

Rendered document content: to organize and structure your code better. E.g: [464936660] Excel Remove Duplicates Range
…
that are duplicated in a specified range. (*for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Range (String
Title: Excel Remove Duplicates Range
Location: Excel Remove Duplicates Range
…
Excel Activities
Raw document content: . E.g: [464936660] Excel Remove Duplicates Range ))) {{velocity}} #if ($xcontext.action != 'export
…
" %) ((( RCA.Activities.Excel.ExcelRemoveDuplicatesRange == **Description** == Deletes all the rows that are duplicated in a specified range
…
" * **Range (String)** - The range from which you want to remove duplicate rows. E.g: "A1:H5

Excel Set Range Color

Located in

Last modified by Giang Tran on 2022/05/13 06:48

Rendered document content: 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
Title: Excel Set Range Color
Location: Excel Set Range Color
…
Excel Activities
Raw document content: " %) ((( 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

Excel Copy Paste Range

Located in

Last modified by Giang Tran on 2022/05/13 04:28

Rendered document content: 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
Title: Excel Copy Paste Range
Location: Excel Copy Paste Range
…
Excel Activities
Raw document content: )** - 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

Read Range

Located in

Last modified by Giang Tran on 2022/05/13 06:53

Rendered document content: 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
Title: Read Range
Location: Excel Activities
…
Read Range
Raw document content: " %) ((( 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

Excel Set Border

Located in

Last modified by Giang Tran on 2022/05/13 06:28

Rendered document content: RCA.Activities.Excel.ExelSetBorder Description The activity allows you to set the borders through different ranges in Excel. This only can be used in Excel Application Scope Activity. (* is mandatory
…
. E.g: “Employee Infomation” Range (String)* - The Range that you want to border. E.g: “A1:K10” Misc
Title: Excel Set Border
Location: Excel Activities
…
Excel Set Border
Raw document content: " %) ((( RCA.Activities.Excel.ExelSetBorder == **Description** == The activity allows you to set the borders through different ranges in Excel. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H
…
Infomation” * **Range (String)*** - The Range that you want to border. E.g: “A1:K10” **Misc

Excel Insert Rows

Located in

Last modified by Giang Tran on 2022/05/13 06:22

Rendered document content: 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
Title: Excel Insert Rows
Location: Excel Activities
…
Excel Insert Rows
Raw document content: 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