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:
In the Select Service page, you select the system type and specify the OData service you want to bind to the add-in.
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:
Displays the list of collections in the selected service. Select the collection you want from the list.
GWM Excel Add-in does not support collections with complex property type.
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.
The wizard presents icons and buttons in all pages. Use these to perform the following activities:
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.
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.
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.
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:
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.
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.