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).

[ Up to Work With Form Applications Option 1 ]