|
Read Multiple Cells
Reads multiple cells from an open Microsoft Excel Document, and stores the read data into an array.
Parameters
-
Document name Specifies the document for reading.
-
Worksheet name Specifies the worksheet which contains the cell to be read.
-
Columns Specifies the columns to be read.
-
Rows Specifies the rows to be read.
-
Read what Specifies which property of the cell to be read, it can be Value, hyperlink, formula.
-
Populate variable with result Specifies the name of the variable that will store the read data.
-
Populate variable with state of exceeding rows 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.
Notes
- Re-define the variable is not necessary. The variable will be converted to an array automatically.
- The document must be opened by the instruction "Open Document" or "Create a Microsoft Excel Document" , or be connected by the instruction "Connect an Open Document" before this step.
- Microsoft Excel program must be present in the computer before playing a macro which contains this action.
|