Search: excel-read-range

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

Range (String)* - The range that you want to read. If the range isn't specified, the whole spreadsheet

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

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

Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t

Read Range

Read Range

Excel Activities

" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store in a DataTable variable. If the range isn’t specified, the whole spreadsheet starting from that cell is read

) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read

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 Read Cell

Excel Activities

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

of the sheet contains the cell which is aimed to be read. If there is no amendment, “Sheet1” is automatically

can edit the name of the activity to organize and structure your code better. E.g: Excel Read Row

RCA.Activities.Excel.ExcelReadRow Description This activity allows you to reads the values of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable

Excel Read Row

Excel Read Row

Excel Activities

. You can edit the name of the activity to organize and structure your code better. E.g: Excel Read Row

RCA.Activities.Excel.ExcelReadRow == **Description** == This activity allows you to reads the values of an Excel row beginning from the cell specified in the StartingCell field: and stores

the name of the activity to organize and structure your code better. E.g: [482156710] Excel Read Column

RCA.Activities.Excel.ExcelReadColumn Description Read all data into column has determined (* for mandatory) In the body of activity Sheet name - The sheet you want to read. E.g: "Sheet1" Starting Cell

Excel Read Column

Excel Read Column

Excel Activities

your code better. E.g: [482156710] Excel Read Column **Options** * **Preserve Format (Boolean

RCA.Activities.Excel.ExcelReadColumn == **Description** == Read all data into column has

** == * **Sheet name** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell** - The cell from which

. E.g: Excel Append Range

in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body of activity Sheet Name - The name of the sheet in which to add the specified range. By default

Excel Append Range

Excel Append Range

Excel Activities

the name of the activity to organize and structure your code better. E.g: Excel Append Range

to the end of a specified Excel spreadsheet. [[image:image-20220505131238-1.jpeg]] (* is mandatory) == **In the body of activity** == * **Sheet Name** - The name of the sheet in which to add the specified range

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

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 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

range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope

of the activity to organize and structure your code better. E.g: Write Range Excel Options Add Headers (Checkbox

. E.g: “A10” Data Table - The data that you want to write to the specified range, as a DataTable

Excel Write Range

Excel Write Range

Excel Activities

Range Excel **Options** * **Add Headers (Checkbox) **- When selected, column headers are also written

with the value specified in the Sheetname property. All cells within the specified range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505114134-2

] 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

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

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