Search: excel-select-range

Input Change Mode (Dropdown List) - Selects whether the activity adds or removes columns. ・Add: Add

to organize and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns Options

Excel Insert Or Delete Columns

Excel Activities

Excel Insert Or Delete Columns

) **- Selects whether the activity adds or removes columns. **・Add**: Add columns to the document. **・Delete

and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns **Options** * **CopyOrigin

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

RCA.Activities.Excel.ExcelReadCell Description This activity allows to read value of an Excel cell and store it in a variable. It is only be used inside the Excel Application Scope activity

to be read. If there is no amendment, “Sheet1” is automatically selected. “Cell” - Specified cell need has

Excel Read Cell

Excel Activities

Excel Read Cell

" %) ((( RCA.Activities.Excel.ExcelReadCell == **Description** == This activity allows to read value of an Excel cell and store 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

the name of the activity to organize and structure your code better. E.g: [482156710] Excel Read Column Options Preserve Format (Boolean) - Selecting this check box keeps the formatting of the column that you

Excel Read Column

Excel Activities

Excel Read Column

your code better. E.g: [482156710] Excel Read Column **Options** * **Preserve Format (Boolean) **- Selecting this check box keeps the formatting of the column that you want to read. By default, the check box

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

Excel Read Range

Excel Read Range

Excel Activities

" %) ((( 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

of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable

can edit the name of the activity to organize and structure your code better. E.g: Excel Read Row Options Preserve Format (Boolean) - Selecting this check box keeps the formatting of the row that you

Excel Read Row

Excel Activities

Excel Read Row

the values of an Excel row beginning from the cell specified in the StartingCell field: and stores

. You can edit the name of the activity to organize and structure your code better. E.g: Excel Read Row **Options** * **Preserve Format (Boolean) **- Selecting this check box keeps the formatting of the row

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

Excel Remove Duplicates Range

Excel Remove Duplicates Range

Excel Activities

. 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

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

Excel Select Range

Excel Select Range

Excel Activities

" %) ((( 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