Excel Wizard screen allows you to define your Excel message format according to your own file format.

To define a message in Excel format, select an existing template or make a copy of the MS Excel template in the catalogue.

File sample

Following is a sample Excel file having headers at the first row of the Excel sheet.

Figure 1.39. Excel Sample file

Wizard screen

When you create a new message format, you must first configure it using the following wizard.

Figure 1.40. Excel Wizard screen 1

After uploading the file sample, you should click 'Save' button to let the system build the corresponding message definition for your file sample.

Figure 1.41. Excel Wizard screen 2

Hint: If your file sample contains headers at the first row, so you should check the box "Contains header ?" at the end of the wizard.

Edit screen

Once this message format has been saved, or when it is used or copied from a saved format, edit screen appears as follows.

Figure 1.42. Excel Edit screen

See Message Edit Functions for further information on message definition, contextual menu and additional commands available on this screen.