Previous Topic: OmWebServiceServicePortTypeClientNext Topic: SOAP Requests


Microsoft Office Excel

Microsoft Office Excel plugin is created as Visual Studio Tools for Office ( VSTO ) solution. For more information, see the Microsoft documentation How to: Create Visual Studio Tools for Office Projects.

The code accessing OM Web Services (WCF client proxy) looks alike as in case of VB/C# samples.

Note: The sample project can be found in the samples/dotNET/Excel folder on the OM Web Services CD. It requires Microsoft Visual Studio 2010 Professional SP1 and .NET 4.0 or higher.

Follow these steps:

  1. Edit app.config - to set the endpoint address to host and port where Output Management Web Services server is running.
  2. Right-click the project and click Publish in the Solution Explorer

    Installer is created.

  3. Run the installer to add the Excel on the target computer.

    After you open the Excel,"CA Technologies"tab appears This tab has three buttons: Report List, Index List, and Report Data. Input cells are placed in the upper left corner of the sheet.