System: EASY400 User: QTMHHTP1 Generate an XLS/XLSX Excel workbook from db files Release: 2023-11-30
 
  Generate an XLS/XLSX workbook from db files
(CGI program WEBTABLEX2, TABLEXLS2 for the WEB)
 
Data base files:   FROMFILE  
up to 50 qualified file names separated by semicolons.
Example: lib1/file1;lib2/file2		   library/file
Members:   FROMMBR  
up to 50 member names separated by semicolons.
Example: member1;member2		   Names, generic*, *first, *all
To .xml stream file:   TOXML  
To .xls / xlsx stream file:   TOXLS  
Add worksheets to an existing workbook:   ADDTO
Sheet names:   SHEETNAME  
Right to left display:   SETRTL *yes    *no
Frozen pane:   FROZEN
Number of frozen initial rows:  
Number of frozen initial columns:  
Decimal positions:   DECPOS
Display zero values:   ZERODSP *yes    *no
Header:   HEADER
  - print header   Text, *dft, *filetxt, *mbrtxt
  - display also on worksheet *yes    *no
Background color
for column headers: 		  HDGCOLOR  
Default cell colors:   DFTCELLCOL
  - font color
  - background color
Cell borders:   CELLBORDER
  run in a separate
batch job