====== XLS Functions (F6) ======
This is a sample form with XLS template, when *IFSXLS is used as destination queue, the IFS path should be defined in F6=XLS Func
6/07/18 iDocs Form Suite FM0465C3
11:48:40 Define a Form Application KKRAMER
Form Application. . . . . . DEMOXLS Demo XLS Project
Form Size . . . . . . . . . 2 Letter(8 1/2 x 11 in.) F4=List
Collate(Y/N). . . . . . . . . . . N Use Mapped Fields Only (Y/N). . . Y
Page Orientation. . . . . . P F4=List Pages per Overlay (1-9) . . . . . 1
Front Map File. : F4=List Back Map File . . : F4=List
X adjustment value. . . . . . . . 0 Y adjustment value. . . . . . . . 0
Color Output . . . . . . . N F4=List
Front Side Back Side Form Destination
Overlay Seq Drawer Merge Overlay Merge Prompt Out Queue
F4=List # F4=List Data F4=List Tumble Data F4=List F4=List
TEMPLATE.XLS 1 1 Y *STD *IFSXLS
More...
F2=Data Map F3=Exit F6=XLS Fnc F7=Footer F8=Mapped Fields F9=Adv Functions
F10=Extra Pages F12=Cancel F15=Global Offset F16=Idriver F17=Import Map
F6 XLS Settings screen:
iDocs XLS Settings
IFS Output Folder: /idocs/xls
XLS File Name. . : ABC
Spool pages in separate sheets: Y Y/N
Overwrite . . . : Y Y/N
F3=Exit F4=Prompt F10=Save
* **IFS Output Folder**: If you want to save the output to a directory fill this is with the directory path, otherwise leave blank.
* **XLS File Name**: Fill in the name you want to call the XLS file.
* **Spool Pages in separate sheets**: Y/N Y=Each spool page will be merged and write to a separating sheet of the output file; N=No, too keep in one sheet.
* **Overwrite**: = Y=Yes, for overwriting already exciting files with same name (mainly when saving to directory); N=No, for saving with an appending number.
When the form is merged with spool file, the XLS output file will be outputted to the IFS output folder with the specified name in XLS File Name (if any).
----
[[[defineformopt1 | Up to Work With Form Applications Option 1 ]]]