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 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 instruction.