Steer Excel UI
You can create Microsoft Excel UI Modules with Tosca XScan to steer Microsoft Excel.
To do so, right-click a Module folder or use the dynamic menu Modules in Tosca Commander, click Scan and select Application. For more information on scanning, see chapter "Scan Modules".
Steer the Microsoft Excel main window
Excel UI Engine 3.0 allows you to steer the user interface in the Microsoft Excel main window. This UI consists of a basic set of controls (buttons, comboboxes, menus, etc.), which are handled in the standard way by Tosca TBox. For further details, see chapter "Steering Controls".
Steer Microsoft Excel worksheets
Steer worksheet
Excel UI Engine 3.0 also allows you to steer Microsoft Excel worksheets.
The Excel UI Engine 3.0 treats an entire worksheet as a single table, which you can steer as described in chapter "Table". Note the following:
-
The read-only row containing column letters, displayed in Excel above the row "1" of the worksheet, is included in the table and by default chapter "Scan tables".
-
The read-only column containing row numbers, displayed in Excel to the left of column "A" in the worksheet, is included in the table and by default chapter "Scan tables".
Steer embedded controls
Microsoft Excel provides two separate sets of controls which can be added to worksheets: Form Controls and ActiveX controls.
The table below lists all Excel controls that you can scan and steer withTosca.
Name of Excel control |
Type |
Identified in XScan as |
---|---|---|
Form Control |
Button |
|
Form Control |
CheckBox |
|
Form Control |
ComboBox |
|
Form Control |
ListBox |
|
Form Control |
RadioButton |
|
ActiveX Control |
CheckBox |
|
ActiveX Control |
Button |
You can scan and steer WinForms controls embedded in worksheets using the DotNet Engine 3.0. To do so, right-click the Excel window in ToscaXScan and select DotNet from the engine list. For more information on scanning with Tosca XScan, see chapter "Navigate the Tosca XScan UI". |
Steer Microsoft Excel dialogs
Excel UI Engine 3.0 allows you to steer Microsoft Excel dialogs by creating a separate module for each dialog that you want to steer.
To steer Microsoft Excel dialogs, follow the steps below:
-
Open the dialog window that you want to steer.
-
From Tosca Commander, scan it with Tosca XScan as an application.