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:18] – kkramer | pub:formatxtemplates [2018/07/25 17:41] – [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: | ||
Line 51: | Line 55: | ||
* Overwrite = Y=Yes, for overwriting already exciting files with same name (mainly when saving to directory); N=No, for saving with an appending number. | * Overwrite = Y=Yes, for overwriting already exciting files with same name (mainly when saving to directory); N=No, for saving with an appending number. | ||
+ | F6 XLS Settings screen: | ||
+ | < | ||
+ | iDocs XLS Settings | ||
+ | |||
+ | IFS Output Folder: | ||
+ | |||
+ | XLS File Name. . : ABC | ||
+ | |||
+ | Spool pages in separate sheets: | ||
+ | Overwrite | ||
+ | |||
+ | F3=Exit | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | </ | ||
+ | Lastly, for the Destination Out Queue use *EMAILXLS to output as XLS when emailing out. | ||
+ | |||
+ | |||
+ | Testing with iMail when doing a manual merge… | ||
+ | When testing, select the Form Application with 15 to merge with a spool file | ||
+ | Then select the spool file with option 11 to merge and email | ||
+ | When sending the email, change the TYPE field to *XLS to send out as an XLS format. | ||
pub/formatxtemplates.txt · Last modified: 2022/06/25 17:02 by 127.0.0.1