Support Import

Read from Excel Worksheet
Description:

This action reads the value of a cell or a range of cells from the active worksheet of a previously launched Excel Instance:

readfromexcel.png
readfromexcel2.png

Properties:

Excel Instance:

Enter the variable that contains the Excel Instance you want to work with. You must have previously specified this variable in a Launch Excel action.

Retrieve:

Choose whether to retrieve the value of a single cell or a table from a range of cells.

Start Column:

Enter a numeric value to be the cell column or starting column number. This must be a number. For example, Column F requires the entry of '6'.

Start Row:

Enter a numeric value to be the cell row or starting row number.

End Column:

Enter a numeric value to be the ending column number. This must be a number. For example, Column J requires the entry of '10'.

End Row:

Enter a numeric value to be the ending row number.

Advanced Properties Tab - Get Cell Contents as Text:

Check this to retrieve the content of the cell(s) purely as text. Leave this option unchecked if you want the action's output variable type to match (as closely as possible) the source cell's data type. In that case, a date in Excel will be stored as DateTime variable in ProcessRobot, numbers as numeric variables etc.

Advanced Properties Tab - First line of range contains column names:

Choose whether this action considers the first row as column names. If it does, the names won't be read as data into the table, and later actions can search the data by column names.

Store Cell Value(s) into:

Enter a name to be the variable that will store the value of the single cell or a table from the range of cells.