iDocs will use the Form Application to hold the instructions to follow to create the output as an Excel sheet which is formatted. There will be similarities to the structure of the Form Application. For the Front Side Overlay field we’ll use a Excel file (.XLS) instead of the Macro file (.MAC); for the Mapped Field we’ll use one of three different Map Types…
- Map Type 8 = *XLS Header Field
- Map Type 9 = *XLS Detail Field
- Map Type 1 = *XLS Total (Footer) Field
The Map Field’s To/From Rows and Columns will select the data on the spool file which you want to use to appear on the Excel sheet.
The Map Fields will correspond to the Cell Location and Name on the Excel sheet which will be use as the overlay/template.
For example if you have Mapped Field side01001 on the Form Application and the Map Type is 8 as the header and you position the Map Field name in a cell location on the Excel sheet that is on top, the data will appear in that location in the cell. This will become easier to see as you setup your first Form Application.
Create and format the Excel sheet:
Open Excel and start to position your Map Field name in the location you want them to appear.
Note: You may find it easier to first map the field name on a Form Application so you know which fields will be header fields and which fields will be detail fields and to see the field names..