Reading an entire worksheet into a collection

Now that we have the Excel worksheet opened, we can instruct the robot to read its contents. If you look at the list of available actions in the MS Excel VBO library, you will see the following possible actions to choose from:

• Get worksheet as collection: Reads everything from cell A1 to the last populated row and column.
• Get worksheet as collection offset: Reads everything from a specified cell to the last populated row and column.
• Get worksheet range as collection: Reads everything from the specified start cell to the specified end cell.
• Get worksheet as collection (Fast): This action has been deprecated. It is still in the list for backward compatibility reasons.

The action that you select depends on how your spreadsheet is formatted. Since our shopping list starts from cell A1, we will use Get worksheet as collection.

1. Drag an...