Search: excel-set-range-color
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
Creator
- 9Giang Tran
- 6admin
- 1DatPT
- 1LongVA
- 1Nga Nguyen
Last modification date
Creation date
Object type
Uploaded by
- 9Giang Tran
- 5admin
- 2LongVA
- 1DatPT
- 1Nga Nguyen
- … 1 more
Upload date
Excel Set Range Color
Located in
- Rendered document content
of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope
…. E.g: Set Range Color
…that contains the cell you want to color. E.g: “Name of the sheet” Range (String)* - The range of data
- Title
Excel Set Range Color
- Location
Excel Set Range Color
…Excel Activities
- Raw document content
(String)*** - The range of data in specified sheet you want to set color. String supported only. E.g: “A1
…of the activity to organize and structure your code better. E.g: Set Range Color ))) {{velocity
…" %) ((( RCA.Activities.Excel.ExcelSetRangeColor == **Description** == This activity allows changing color of a specified cell or cell range
Excel Read Range
Located in
- Rendered document content
of an Excel range and store it in a DataTable variable. If the range is not specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application Scope activity. (* is mandatory) In the body of activity
- Title
Excel Read Range
- Location
Excel Read Range
…Excel Activities
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelReadRange == **Description** == This activity allows you to read the value of an Excel range and store it in a DataTable variable. If the range is not specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application
Excel Select Range
Located in
- 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. By default, this is filled in with "Sheet1". Only String variables and strings are supported. Range (String
- 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 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
Excel LookUp Range
Located in
- 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
…" %) ((( RCA.Activities.Excel.ExcelLookUpRange == **Description** == Searches in a specified range for the coordinates of a cell
…in the workbook where you want to search. E.g: "Sheet1" * **Range (String)*** - The range where you want
Excel Delete Range
Located in
- 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 Set Border
Located in
- 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 Set Border
…Excel Activities
- 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 Remove Duplicates Range
Located in
- 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 Copy Paste Range
Located in
- Rendered document content
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 (String)* - The range of the data you want to copy. This field supports only strings and String variables
- Title
Excel Copy Paste Range
- Location
Excel Copy Paste Range
…Excel Activities
- Raw document content
" %) ((( 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 only strings and String variables. E.g: “Source range” **Misc** * **Public (Checkbox) **- Check
Input Dialog
Located in
- Rendered document content
of the form. E.g: "What is your favorite color?" Options (String[]) - Provides an array of options to choose from instead of textbox. If set to contain only one element, a text box appears to write text. If set
…as a combo box to choose from. Title (String) - The title of the dialog. E.g: "Color Picker" Misc Public
- Raw document content
) **- The text to display as the label of the form. E.g: "What is your favorite color?" * **Options (String[]) **- Provides an array of options to choose from instead of textbox. If set to contain only one element, a text box appears to write text. If set to contain 2 or 3 elements, they appear as radio button to select
CV Highlight
Located in
- Rendered document content
] CV Highlight Options Color (Dropdown list) - Enables you to specify the color of the highlight. A drop-down list with predefined colors is available. Highlight Time (Int32) - The amount of time
…on the same UI element easier. If a variable is set to this field, the current target and anchor elements
- Raw document content
. E.g: [123123] CV Highlight **Options** * **Color (Dropdown list) **- Enables you to specify the color of the highlight. A drop-down list with predefined colors is available. * **Highlight Time (Int32
…, as it makes performing multiple actions on the same UI element easier. If a variable is set to this field
next page »
Page
1
2
RSS feed for search on [excel-set-range-color]