54
CoolSpools Spool Converter User Guide V6R1
Page:
251
www.ariadnesoftware.co.uk
*CALC
CoolSpools will attempt to calculate the column
positions automatically.
*POS
You will specify all column positions manually, on
the COLUMNPOS parameter.
*CALCPOS
CoolSpools will calculate the column positions
automatically, but you will fine-tune the column
positions selected using options on the
COLUMNPOS parameter.
*TOKEN
CoolSpools will calculate the column positions
automatically using a different method which
identifies text "tokens" in the spooled file.
This method may give better results than
COLUMNOPT(*CALC) with spooled files created
from externally described printer files.
Column creation threshold
This option allows you to influence the way in which CoolSpools' algorithm for
calculating column positions operates. The algorithm uses statistical techniques to
identify character positions in the report where left-aligned alphanumeric or right-
aligned numeric columns of data appear. The algorithm will select character
positions where such items occur with a frequency which is more than a given
number of standard deviations from the norm. The value specified here is the
number of standard deviations to use. If the default value (1 standard deviation from
the norm) does not give good results, you can try adjusting this to a different value.
Options are:
1.00
One standard deviation.
0.00-9.99
The number of standard deviations from the mean
to use in the column selection algorithm.
Ignore char position (*TOKEN)
Specifies whether CoolSpools should taken any notice of character position when
implementing the COLUMNOPT(*TOKEN) method.
Options are:
*NO
CoolSpools will identify text "tokens" in the spooled
file and allocate those tokens to columns based on
the character position across the page where the
token is found. If blanks are being used as the
token delimiter, and the value in a column is blank,
this will help ensure that columns align correctly.
*YES
CoolSpools will identify text "tokens" in the spooled
file and allocate those tokens to columns based on
sequential number of the token (i.e. the first such
token is allocated to column A, the second to
column B etc.)
52
CoolSpools Spool Converter User Guide V6R1
Page:
252
www.ariadnesoftware.co.uk
COLUMNPOS
–
Column positions
Parameter
COLUMNPOS
Applies to
commands:
CVTSPLXLS
Dependent on:
This parameter allows you to specify the column positions to be used in the Excel file
(in conjunction with COLUMNOPT(*POS)) or to override the column positions
determined automatically by CoolSpools (in conjunction with
COLUMNOPT(*CALCPOS)).
If you are having difficulty obtaining the results you want using CVTSPLXLS, we
recommend you try using CVTSPLXL command instead. CVTSPLXL requires you to
create a report definition describing the structure and contents of the spooled file you
are converting. It also requires you to create a Report-to-Excel map based on that
report definition which tells CoolSpools how you want your Excel file to be structured
and where to take the information from. While this can seem like a lot of work, you
only need to d it once and, when it’s done, you will be able to produce reliable and
consistent output tailored to your precise needs.
Note that when CVTSPLXLS is run, CoolSpools will send messages to the joblog
regarding the column positions selected. These messages can be helpful in
identifying the column positions you need to modify on the COLUMNPOS parameter.
Single option:
*CALC
No column positions are defined.
COLUMNOPT(*CALC) must be specified.
Other values (up to 100 repetitions):
Spooled file column position
Options are:
1-999
The character position in the report where the
column should be added or removed.
Please note that for a left-aligned column (*LEFT
specified for the third parameter element below),
the position indicated should be the start position
of the column (left-most character position) but for
a right-aligned column (*RIGHT specified for the
third parameter element below), the position
indicated should be the end position of the column
(right-most character position, taking into account
any possible trailing minus sign).
Action at this position:
Single option:
*RMV
The column created by CoolSpools at the specified
character position will be removed.
43
CoolSpools Spool Converter User Guide V6R1
Page:
253
www.ariadnesoftware.co.uk
Use this option to remove unwanted columns
when COLUMNOPT(*CALCPOS) has been
specified.
Other options:
Column action
*ADD
A column will be created at the specified character
position in the report.
Use this option to add extra columns when
COLUMNOPT(*CALCPOS) has been specified, or
to define all column positions required, when
COLUMNOPT(*POS) was specified.
Left or right column?
Options are:
*LEFT
The column is left-aligned. The column position
specified above indicates the start of the column
(left-most position).
*RIGHT
The column will be right-aligned. The column
position specified above indicates the end of the
column (right-most position).
Alpha or numeric column?
Options are:
*ALPHA
The column contains alphanumeric data.
*NUMERIC
The column contains numeric data.
Column width
Options are:
*CALC
The column width will be calculated from the
position of adjacent columns.
width
The column width in characters, measuring to the
right for a left-aligned column and to the left for a
right-aligned column. For the best results, it is
recommended that the column width be specified
manually using this option.
54
CoolSpools Spool Converter User Guide V6R1
Page:
254
www.ariadnesoftware.co.uk
LINTYPES
–
Line types
Parameter
LINTYPES
Applies to
commands:
CVTSPLXLS
Dependent on:
This parameter allows you to tell CoolSpools explicitly what type of line each line in
your report is, to influence whether lines are treated as unwanted headings or not,
and to override the column structure used for the main body of the spreadsheet in
relation to certain lines.
Note that this parameter of the CVTSPLXLS command does not allow anywhere
near the same degree of control and precision that the CVTSPLXL command does.
If you are having difficulty obtaining the results you want using CVTSPLXLS, we
recommend you try using CVTSPLXL command instead. CVTSPLXL requires you to
create a report definition describing the structure and contents of the spooled file you
are converting. It also requires you to create a Report-to-Excel map based on that
report definition which tells CoolSpools how you want your Excel file to be structured
and where to take the information from. While this can seem like a lot of work, you
only need to d it once and, when it’s done, you will be able to produce reliable and
consistent output tailored to your precise needs.
Single values:
*NONE
No line types are defined. CoolSpools will attempt
to identify the type of line using statistical and
positional criteria.
Other values (up to 100 repetitions):
From page number
Options are:
*FIRST
The first page.
*LAST
The last page.
from-page
Specify the first page number to which the
definition relates.
A negative number is interpreted as counting from
the end of the report. For example, -1 is the last
page, -2 the penultimate page etc.
To page number
Options are:
*LAST
The last page.
*FIRST
The first page.
to-page
Specify the last page number to which the
definition relates.
56
CoolSpools Spool Converter User Guide V6R1
Page:
255
www.ariadnesoftware.co.uk
A negative number is interpreted as counting from
the end of the report. For example, -1 is the last
page, -2 the penultimate page etc.
From line number
Options are:
*FIRST
The first line.
*LAST
The last line.
from-line
Specify the first line number to which the definition
relates.
To line number
Options are:
*LAST
The last line.
*FIRST
The first line.
to-line
Specify the last line number to which the definition
relates.
Line type
What type of line this is.
Options are:
*PAGHDG
The line is a page heading. The lines selected will
be treated as page headings for the purposes of
suppressing page headings (see option on EXCEL
parameter).
*COLHDG
The line is a column heading. The lines selected
will be treated as page headings for the purposes
of suppressing column headings (see option on
EXCEL parameter).
*OTHER
The line is not a detail line, page heading or
column heading (e.g. summary line, total etc.). It
will not be subject to either the option for
suppressing page headings or that for suppressing
column headings (see options on EXCEL
parameter).
Conversion method
How the data for this line should be handled.
Options are:
*COLUMNS
CoolSpools attempts to assign the data to the
column structure in an appropriate way. If this
does not give good results for you, use CVTSPLXL
instead of CVTSPLXLS.
*LINE
The data is treated as a single line of text and not
broken up into columns.
C# Word - Convert Word to HTML in C#.NET VB.NET How-to, VB.NET PDF, VB.NET Word, VB toolkit SDK, preserves all the original anchors, links, bookmarks and font C#: Convert Word document to HTML5 files.
add bookmarks pdf; bookmark pdf acrobat
49
CoolSpools Spool Converter User Guide V6R1
Page:
256
www.ariadnesoftware.co.uk
Keep line?
If and when lines of this type are retained in the output or dropped.
Options are:
*DFT
Default action:
If the line is identified as a page heading
(*PAGHDG specified above), the option from
the EXCEL parameter controlling the dropping
of page headings applies
If the line is identified as a column heading
(*COLHDG specified above), the option from
the EXCEL parameter controlling the dropping
of column headings applies
If the line is identified as another type (*OTHER
specified above), duplicate lines after the first
are dropped.
*NONE
All lines identified by this parameter are dropped.
*ALL
All lines identified by this parameter are retained.
*FIRST
All duplicate lines identified by this parameter after
the first are dropped.
Key string to check for
Specifies a key string to be checked. Only lines which match the page and line
criteria above and which also contain this (case-sensitive) key string will be selected
by this rule.
Options are:
*NONE
No key string is checked. Just the page and line
criteria apply.
key
Specify the key string to be checked for.
Line type name
Specifies a name for the line type. This name can be used to identify the line type on
the APYSTYLES and CNDFMTGRP parameters.
Options are:
*NONE
No name is assigned to the line type
line_type_name Specify a name for the line type. The name can be
up to 20 characters in length but must otherwise
conform to the normal rules for OS/400 names.
22
CoolSpools Spool Converter User Guide V6R1
Page:
257
www.ariadnesoftware.co.uk
XLSADJUST
–
Adjust pages to
Parameter
XLSADJUST
Description
Specifies the percentage scaling when XLSPRINT(*ADJUST...)
is requested.
Applies to
commands:
CVTSPLXL
Dependent on: XLSPRINT(*ADJUST)
Specifies the percentage scaling when XLSPRINT(*ADJUST...) is used.
Options are:
100
Scale by 100% (no change).
0-400
Specify the percentage scaling.
35
CoolSpools Spool Converter User Guide V6R1
Page:
258
www.ariadnesoftware.co.uk
XLSFIT
–
Fit pages to
Parameter
XLSFIT
Description
Specifies the number of pages to fit the output to when
XLSPRINT(*FITPAGE...) is requested.
Applies to
commands:
CVTSPLXL
Dependent on: XLSPRINT(*FIT)
Specifies the number of pages to which the output is fitted when XLSPRINT(*FIT...)
is used.
There are two elements:
The number of pages wide (horizontal).
Options are:
*AUTO
Excel will calculate the number of pages required
automatically.
0-65535
Specify the number of pages to which the data
should be fitted horizontally.
The number of pages tall (vertical).
Options are:
*AUTO
Excel will calculate the number of pages required
automatically.
0-65535
Specify the number of pages to which the data
should be fitted vertically.
33
CoolSpools Spool Converter User Guide V6R1
Page:
259
www.ariadnesoftware.co.uk
XLSCOLUMNS
–
Excel columns
Parameter
XLSCOLUMNS
Applies to
commands:
CVTSPLXLS
Dependent on:
This parameter allows you to fine-tune the decisions made by CoolSpools with
regard to the allocation and formatting of data in columns in an Excel spreadsheet.
Up to 100 actions may be specified.
The single value *NONE indicates that there are no Excel column actions defined.
The options are
*DROP
Drop the column and the data it contains from the
output.
*MRGLFT
Merge the column and the data it contains with the
column to the left.
*MRGRGT
Merge the column and the data it contains with the
column to the right.
*ALNLFT
Align the column to the left.
*ALNRGT
Align the column to the right.
*CVTLBL
Create a label not a numeric cell.
54
CoolSpools Spool Converter User Guide V6R1
Page:
260
www.ariadnesoftware.co.uk
XLSPRINT
–
Excel print setup
Parameter
XLSPRINT
Description
Specifies Excel print options
Applies to
commands:
CVTSPLXL
Specifies print options for Excel spreadsheets.
Scaling
How the data is enlarged or reduced when you print so that it fits the required
number of pages.
Specify *FIT and a number of pages wide and tall on the XLSFITPAGES parameter
to fit the data to the required number of pages.
Specify *ADJUST and a percentage on the XLSADJUST parameter to scale the data
by that percentage.
Options are:
*FIT
Fit the data to a number of pages wide and a
number of pages tall. The number of pages wide
and tall are specified on the dependent parameter
XLSFIT.
*ADJUST
Adjust the data by applying a percentage scaling.
The percentage by which the data is scaled is
specified on the dependent parameter
XLSADJUST.
Print gridlines
Whether gridlines should be printed or not.
Options are:
*NO
Gridlines are not printed.
*YES
Gridlines are printed.
Printer header rows on each page
Whether header rows should be printed on each page. The header rows in this
context are the rows that were specified as being frozen at the top of the page on the
EXCEL parameter.
Options are:
*NO
The header rows, if there are any, are printed only
on the first page.
*YES
The header rows, if there are any, are printed on
each page.
Page breaks
Whether CoolSpools should insert page breaks in the Excel file at the end of each
page in the original spooled file.
Documents you may be interested
Documents you may be interested
