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.
To create a template using the GWM Excel add-in wizard, proceed as follows:
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.
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.
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.
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.