pub:formatxtemplates
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
pub:formatxtemplates [2018/07/25 17:24] – kkramer | pub:formatxtemplates [2018/07/25 17:43] – [Create and format Excel Templates] kkramer | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | |||
+ | < | ||
+ | |||
+ | |||
====== Create and format Excel Templates ====== | ====== Create and format Excel Templates ====== | ||
Line 41: | Line 45: | ||
Setup the Form Application with Mapped Fields: | Setup the Form Application with Mapped Fields: | ||
- | If you have not create a Form Application already, then at this time you will want to create a Form Application. | + | If you have not create a Form Application already, then at this time you will want to **[[defineformopt1 | |
Helpful tip: You may want to use iMap to Map the spool file data, and then change the Map Type after you upload to iDocs on the IBMi.\\ | Helpful tip: You may want to use iMap to Map the spool file data, and then change the Map Type after you upload to iDocs on the IBMi.\\ | ||
- | Create the Form Application with the Mapped Fields using one of the three Map Types for *XLS.\\ | + | Create the Form Application with the **[[configuredatamap# |
Enter the newly created XLS name under the Front Side Overlay field.\\ | Enter the newly created XLS name under the Front Side Overlay field.\\ | ||
Within the Form Application select option F6 = XLS Fnc to configure the following: | Within the Form Application select option F6 = XLS Fnc to configure the following: |
pub/formatxtemplates.txt · Last modified: 2022/06/25 17:02 by 127.0.0.1