Sample Excel Communicator Interface

Note

This article applies to Visual Studio 2015. If you're looking for the latest Visual Studio documentation, see Visual Studio documentation. We recommend upgrading to the latest version of Visual Studio. Download it here

The sample IExcelUICommunication interface is used in the ExcelUICommunicator object in the ExcelAddIn project.

IExcelUICommunication Interface

This interface defines the communication points between the CodedUIExtension, which runs in the Coded UI Test process, and the ExcelCodedUIAddIn, which runs in the Microsoft Excel process.

The ExcelCodedUIAddinHelper assembly has a ExcelUICommunicator class that derives from this interface and uses the Excel object model to process the methods.

Some methods get the requested information from Excel then create and return one of the information objects, such as the CellInformation object.

Other methods use a provided information object, find the corresponding control in Excel, and perform some process on the control. For example, the ScrollIntoView method scrolls the Worksheet so that the designated cell is visible.

CodedUIExtensibilitySample and ExcelCodedUIAddinHelper Communication

The ExcelCodedUIAddinHelper assembly runs in the Excel process and has the UICommunicator class that implements the IExcelUITestCommunication interface and gets or sets the required information directly from the Excel UI.

The CodedUIExtensibilitySample assembly runs in the Visual Studio Coded UI Test process. This assembly has the Communicator class that opens a .NET Remoting channel, and provides an Instance property that uses the IExcelUICommunication interface to use the UICommunicator object in the ExcelCodedUIAddinHelper assembly to pass requests and information objects, such as a CellInformation object, back and forth between the two assemblies.

See Also

Extending Coded UI Tests and Action Recordings to Support Microsoft Excel Sample Excel Add-In for Coded UI Testing Sample Coded UI Test Extension for Excel