Read Range

This action is used to read a given range of the excel document.

Properties

Input

• Excel Document: File name for the target Excel document.

• WorkSheet: The target worksheet name.

• Cell Range: The target range.

• Use Header: Specifies if the action should use the first row in defining the column names. True/False.

The target range needs to be specified as an "A1" notation. Example "A1:D5". If left empty, the whole sheet will be captured.

If the WorkSheet property is left empty, the first sheet from the active document will be chosen.

Output

• Output: The name of the variable used to store the value.

The variable must be a DataTable.

Misc

• Display Name: action display name in your implementation project

• Wait Before: number milliseconds robot to wait before executing the action.

• Wait After: number milliseconds robot to wait until moving to the next action.

• Abort on Error: True/False

• Retry Times: Specifies the number of times to retry an action if it doesn't end successfully. Default value 0 (no retry); Use -1 if you want to retry indefinitely.

Use Case

Potential Use Cases

• Extract only the relevant cells from an excel file.

Examples of Using Read Range

Example

Watch the robot in action:

You can check and download the example from here:

6KB

Read Range.zip

archive