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

Button

Form Control

Button

Check Box

Form Control

CheckBox

Combo Box

Form Control

ComboBox

List Box

Form Control

ListBox

Option Button

Form Control

RadioButton

Check Box

ActiveX Control

CheckBox

Command Button

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:

  1. Open the dialog window that you want to steer.

  2. From Tosca Commander, scan it with Tosca XScan as an application.