Creating GWM Excel Add-In Template

Creating a template using the GWM Excel add-in wizard.

GWM Visual Studio add-in comes with the GWM Excel add-in wizard to help you to quickly and easily create templates for GWM Excel add-in applications.

Using the GWM Excel Add-in Wizard

Context

To create a template using the GWM Excel add-in wizard, proceed as follows:

Procedure

Open Microsoft Visual Studio, and choose New Project. The New Project window appears.
From the Visual C# node in the Starter page, choose GWM GWM Excel 2010 Add-in . A default project name displays, you can change the name, and press OK. The GWM Excel 2010 Add-in wizard opens, and the Select Service page displays.
There are two wizards, GWM Excel 2010 Add-in and GWM Excel 2013 Add-in in Visual Studio 2013.
In the Select Service page, select the System Type from the dropdown as Gateway (NetWeaver Gateway), SMP (SAP Mobile Platform) or Azure (Azure Cloud Services) and then, you can do one of the following:
- Enter the URL of the OData service in the Service URL field, and click Go. Provide system specific authentication details if prompted.
  The service URL is the path to access the service document of the OData service and is system specific. The format of the service URL is based on the system type selected:
  - Gateway: "http(s)://<Host>:<Port>/<Gateway Service Endpoint>/"
  - SAP Mobile Platform (SMP): "http(s)://<SMPServer>:<Port>/<AppID>" or "http(s)://<SMPServer>:<Port>/<AppID>/<ConnectionName>"
  - Azure: "http(s)://<Host>:<Port>/<ProviderSystemName>/<Gateway Service Endpoint>"
- Click Browse to open the Browse Services window.
  In the Browse Services window, you can search for the OData service you want. Provide your login credentials and connection settings to connect to the selected system, and choose Connect. Search for the service from the list displayed by providing the service name, service description, application name or provider name in Search, and then choose Select Service. The Select Service page displays the URL of the selected service.
  
  Note
  Only Basic authentication is supported when accessing OData services through SMP and OAuth authentication in Azure. Ensure that the system status is Connected to see the refreshed list of services under each provider. Otherwise, only services from the last fetch will be shown.
Choose Next. The Select Collection page opens.
You can navigate and view the details of each collection in the service. For each collection, a list of properties and the available functionality, Create, Update, and Delete are displayed on the right pane.
Select the collection you want, and choose Next. The Select Properties page displays.
Choose the properties you want as column headers in Excel.
Keys are required, and they appear at the top of the list. Selection for the properties designated as keys cannot be removed, however, you can change their position.
You can choose several properties to add to the Excel sheet. By default, all the properties are selected.

To select all or remove selection for all the checkboxes, choose the checkbox in the column header for the checkboxes.

Use the arrow icons on the right to move the selected property up or down. Property listed at the top will open in the first column in Excel, and the property after the first appears in the column to the right. The rest of the properties follow in that order.
Click Next, the Configure Settings page appears.
- Following are preferences you can customize:
  - Starting reference cell:
    
    By default it specifies A1. Click to specify the cell you want.
  - Maximum records to fetch:
    
    By default it specifies 100. Click to specify the maximum number of records you want to have in Excel.
  - Select a value for the Column header:
    
    By default it specifies Property Name. The options are Property Label and Both. Click to specify the property parameter to use.
- User Operations Setting
  - Enable Records Creation
    
    When selected, the Create operation supported in the service is enabled.
  - Enable Records Update
    
    When selected, the Update operation supported in the service is enabled.
  - Enable Records Deletion
    
    When selected, the Delete operation supported in the service is enabled.
The options are available and selected by default, if the capabiltiy is supported in the selected collection.
Choose Generate Project to generate the project resources.

Results

You can build and run the generated add-in project.