Excel

Create File

Select to create a new Excel workbook.

Open File

Select to open an existing Excel workbook.

Direct Access

Select source from a file.

Via RFS

Select source from a remote file sharing source.

From Variable

Select source from a variable.

• For direct access or RFS source, type the full path to the workbook.

  For example, c:/documents/myworkbook.xlsx

• For a variable source, select a variable with the binary type that contains the data.

Select to specify the number of rows and columns to show when an Excel workbook opens.

The default is 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.

Select to include cells outside the visible area into the application tree for use with finders.

Cells outside the visible area can only be manipulated by using 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.

To reduce the number of rows and columns included in the tree, use the options Rows and Columns.

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