Help files

Read from Excel Action

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 a DateTime Variable in WinAutomation, 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 the name of the Variable that will store the value of the single cell or a table from the range of cells.

Cautions:

For any Excel-related action to work correctly, Microsoft Excel must be installed on the computer where the process will run.