Modified August 2017
Various operations and options in the Export to XLS process are controlled by settings in the export initialization file, prtxls.ini. If this file is missing or an individual lines/statement is missing, APEX will use the value shown as "Default" in the table below. The ini file is normally stored in the [7,6] directory or equivalent, although when PRTXLS.SBX is invoked from the COMMAND statement of a printer ini file, the ini file specification may be passed as an argument (e.g. COMMAND=SBX:PRTXLS,dsk7:xls123.ini[40,30]).
Note that each of the statements below must reside within the section indicated. Within a section, the order or presence/absence of a given statement is not relevant. The section names are in upper case, are enclosed in square brackets, and are preceded by a blank line. See the sample ini file section.
As with many ini files, lines beginning with semi-colons are comments and are ignored by the file processor. Comments can only occur on their own lines--i.e., cannot be appended to the ends of command lines.
Statement |
Section |
Values |
Default |
Description |
IncludeTotals |
DATA |
0,1,2,3 |
0 |
Determines how lines that appear to be subtotals or totals are handled. 0-omit; 1=treat as data; 2=move to separate columns; 3=convert to formulas. |
IncludeBlankLines |
REMNANTS |
0,1 |
0 |
If set, blank lines are included in Remnants worksheet. |
IncludeDupLines |
REMNANTS |
0,1 |
1 |
If set, duplicate lines are included in Remnants worksheet. (Otherwise only one line per set of duplicates is included.) For example, if set, the Remnants page may have many identical lines containing column headers.) |
SortBy |
REMNANTS |
0,1 |
0 |
If set, Remnants lines are sorted by their contents. |
BGcolor |
ORIG |
See sample ini file |
Silver |
Background color of "Original" worksheet. |
AppendSeqNo |
POST |
0,1 |
1 |
If set, a sequence number is appended to the XLS filename to make it unique. |
SaveToDir |
POST |
Path specification |
|
Directory where the XLS file is saved. |
SendToPC |
POST |
0,1 |
1 |
(Unix only) If set, causes the exported XLS file to be transferred to the PC using ATE/ZTERM FTP protocol. |
Launch |
POST |
0,1 |
1 |
If set, the spreadsheet program (typically Excel) is launched to view the spreadsheet. |
The following statements applied only to the Perl implementation of PRTXLS.SBX and are no longer applicable. |
||||
RemoteServer |
POST |
IP address: port |
n/a |
Specifies the location of a service to generate the XLS file. (Local generation requires that Perl be available and the WriteExcel add-on library be installed.) |
IgnoreLocalServer |
POST |
0,1 |
0 |
Set to force use of RemoteServer even if local generation is available. |
ServerErrorURL |
MISC |
URL |
|
URL of page to display when an error related to the RemoteServer occurs. |
Example
;PRTXLS.INI - Config file for PRTXLS.SBX
[DATA]
IncludeTotals=1
[REMNANTS]
IncludeBlankLines=1
IncludeDupLines=1
SortBy=1
[ORIG]
;BGcolor options: silver,white,red,lime,blue,yellow,magenta,cyan,brown,green,navy,purple,gray,orange
BGcolor=silver
[POST]
AppendSeqno=1
SaveToDir=c:\vm\miame\dsk0\150502
SendToPC=1
Launch=1