|
Read EXCEL Document Cell
Reads the value or formula of a cell from an opened Microsoft Excel Document, and stores the read data into a variable for using later.
Click here to show the figure
Parameters
-
Document name Specifies the document for reading, the document should be opened by the instruction "Open Document" before this step.
-
Worksheet name Specifies the name of the worksheet which contains the cell to be read.
-
Column of cell Specifies the column of the cell, the column should be in range from 'A' to 'IV'.
-
Row of cell Specifies the row number of the cell, the number should be in range from 1 to 65535.
-
Read formula Specifies whether to read either the cell value or formula of the cell.
-
Populate result into variable Specifies the variable to hold the read data.
-
Populate state of exceeding rows into variable Stores the number 1 into the variable if the row number
exceeds the max row in the used range, otherwise, the number 0 will be stored. You could check out the variable's value to determine
if all data have been read/written in the used range.
-
When failed to read from cell Specifies the secondary error level if gets an error during reading. It would be the option follwing:
1¡¢Generate a waring message, and then goto the next step.
2¡¢Generate an error message, and then stop the play or goto the next step according to the setting of error handle of this step.
 Note:
Microsoft Excel program must be present in the computer before playing a macro which contains this instruction.
|
