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.
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).
Note 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.
Important 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.
Note Use of this option can result in very large trees and may decrease the performance.