Excel

With this step you can perform some operations on Excel spreadsheets using the built-in Excel driver. For the list of available actions and other information, see Built-in Excel Driver.

To work with the built-in Excel driver in Robot, Microsoft Excel must be installed on the computer where the step is executed.

The built-in Excel driver is available for both the local automation device (using Microsoft Excel on the DesignStudio/RoboServer host) and remote automation devices (using Microsoft Excel installed on the remote device).

Properties

Action
Create File

Select this option to create a new Excel document.

Open File

Select this option to open an existing Excel document. After you select Open File, specify the full path to the spreadsheet in Worksheet Path. For example, c:/documents/myspreadsheet.xlsx

Visible Area

Specifies the number of rows and columns to show when an Excel document opens (default 45 rows and 20 columns).

The specified number of columns is the minimum number. The Excel driver loads either the specified number of columns or more to fill the entire screen width.

Rows and cells in this area have the Hidden="true" attribute if they are not visible in the Recorder View, because their height or width is set to 0.

Extended Tree

Includes cells outside the visible area into the application tree for use with finders.

Cells outside the visible area can only be manipulated by application and component actions.

If you use this option, all cells in the area that Excel considers 'in use' are included in the application tree. These cells have the Visible="false" attribute if they are outside the visible area.

The number of rows and columns included in the tree can be reduced using the optional Rows and Columns options.

The Extended Tree area is dynamically adjusted to include the entire Visible Area.

Use of this option can result in very large trees and may decrease the performance.