Search: excel-delete-range
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
Last author
- 8Giang Tran
- 3VuNH54
- 2admin
- 1LongVA
Creator
- 11Giang Tran
- 2admin
- 1LongVA
Last modification date
Creation date
Object type
Uploaded by
- 11Giang Tran
- 2LongVA
- 1VuNH54
- 1admin
Upload date
Excel Delete Range
Located in
- Rendered document content
RCA.Activities.Excel.ExcelDeleteRange Description This activity allows deleting a specified range
…variables and strings are supported. E.g: “Employee Data” Range (String)* - The range you want to delete
…. E.g: Delete Range Options ShiftCells (Checkbox) - If you check it, cell formatting is shifted
- 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
…the cells in the deleted range. The available options are ShiftUp, ShiftDown, EntireRow, and EntireColumn
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 Remove Duplicates Range
Located in
- Rendered document content
to organize and structure your code better. E.g: [464936660] Excel Remove Duplicates Range
…RCA.Activities.Excel.ExcelRemoveDuplicatesRange Description Deletes all the rows that are duplicated in a specified range. (*for mandatory) In the body of activity Sheet name (String
- Title
Excel Remove Duplicates Range
- Location
Excel Remove Duplicates Range
…Excel Activities
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelRemoveDuplicatesRange == **Description** == Deletes all the rows that are duplicated in a specified range
…. E.g: [464936660] Excel Remove Duplicates Range ))) {{velocity}} #if ($xcontext.action != 'export
…" * **Range (String)** - The range from which you want to remove duplicate rows. E.g: "A1:H5
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
…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 Insert Or Delete Columns
Located in
- Rendered document content
to organize and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns Options
…columns to the document. ・Delete: Remove columns from the document. Sheet name (String)* - The name
- Title
Excel Insert Or Delete Columns
- Location
Excel Insert Or Delete Columns
…Excel Activities
- Raw document content
and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns **Options** * **CopyOrigin
…) **- Selects whether the activity adds or removes columns. **・Add**: Add columns to the document. **・Delete
Excel Insert Or Delete Rows
Located in
- Rendered document content
whether the activity adds or removes rows. ・Add: Add rows to the document. ・Delete: Remove rows from
…edit the name of the activity to organize and structure your code better. E.g: [038325762] Excel Insert Or Delete Rows Options CopyOrigin (Dropdown List) - There are two opitons for you to format the rows
- Title
Excel Insert Or Delete Rows
- Location
Excel Insert Or Delete Rows
…Excel Activities
- Raw document content
. E.g: [038325762] Excel Insert Or Delete Rows **Options** * **CopyOrigin (Dropdown List
…the activity adds or removes rows. **・Add**: Add rows to the document. **・Delete**: Remove rows from
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
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 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
next page »
Page
1
2
RSS feed for search on [excel-delete-range]