Show TOC

GWM Excel Add-In OverviewLocate this document in the navigation structure

Overview of the GWM Excel Add-in wizard.

You create an add-in for Microsoft Excel using the GWM Excel Add-in wizard, to generate a template for your Microsoft Excel add-in.

The wizard consists of four pages. The following are the pages:

  • Select Service:

    In the Select Service page, you select the system type and specify the OData service you want to bind to the add-in.

  • Select Collection:

    The second page in the wizard is the Select Collection page. In this page, you specify the collection in the OData service you want to use.

    The Service Collections page displays the list of collections. There are two panes:

    • Service Collection:

      Displays the list of collections in the selected service. Select the collection you want from the list.

    • Properties:

      Presents for viewing the list of properties in the selected collection. In the Properties pane, there are icons above the listed properties; these indicate the Create, Update and Delete capabilities supported in the collection.

      GWM Excel Add-in does not support collections with complex property type.

  • Select Properties:
    The third page in the wizard is the Select Properties page. In this page, you define the properties you want in the Excel add-in, and configure them as column heading items.
    Note Properties that are not selected are hidden and are updated as null values when changes are submitted. To avoid this, see Values of Hidden Properties Updated as Null Values.
  • Configure Settings

    The fourth and last page in the wizard is the Configure Settings page. In this page, you specify the configuration settings for presenting and viewing data in Excel, and whether to allow the Create, Update and Delete capabilities on the data retrieved into the bound Excel worksheet.

To configure the template to interface with the OData service you want in the connected SAP Gateway system, follow the steps in the wizard pages, sequentially.

Navigating the Wizard Pages

The wizard presents icons and buttons in all pages. Use these to perform the following activities:

  • Cancel button:

    The Cancel button is always enabled in all pages.

    When you choose the Cancel button a popup window displays asking you to confirm your action of closing and exiting the project without saving any changes.

  • Next button:

    The Next button is enabled in the first three pages of the wizard.

    In each page, the Next button is enabled only when the required fields have entries.

  • Back button:

    The Back button is enabled from the second page of the wizard.

You can navigate from page to page to edit your entries, however, when you edit an existing entry, a message displays to inform you that you will lose all the settings you defined previously.

Binding the OData Service to the Microsoft Excel Add-In

In the first wizard page, Select Service, select the system type and specify the OData service you want to bind to the add-in, in one of the following ways:

  • In the Service URL field, enter the URL of the OData service you want to bind and choose the Go button to validate it.
  • Choose Browse to open the Browse Service window. Provide your login credentials and the connection settings to connect to the selected system and choose Connect.

    A status message appears in the pane, when the wizard is attempting to connect, or it is connected. When the wizard cannot connect to the specifiied system, an error message is shown.

Within the Browse Service window, you can expand and collapse the Connection to Service Server pane. The Service pane appears below the connection settings pane. From the Service pane, you can choose Select service, to bind the OData service you want to the Excel worksheet.

Completing the Wizard

The Configure Settings page is the last page in which you can generate the template into your project.

Choose Generate Project to complete the wizard. When you complete the steps in the wizard, a set of resources and code are generated into the project that you define.

In addition, a summary page opens in your browser to present information of the generated code and resources. You can build and run the generated resources for your template, or customize it for your purposes. Later, you can package and deploy your template in Microsoft Excel as an add-in application.