52
CoolSpools Spool Converter User Guide V6R1
Page:
152
www.ariadnesoftware.co.uk
It is important that CoolSpools knows what currency symbol is used in the report so
that it can correctly identify columns of numbers that include a currency symbol as
numeric data rather than treating them as text.
Options are:
*SYSVAL
The currency symbol defined by the QCURSYM
system value is used in the report.
currency_symbol Specify the currency symbol used in the report if
this is different from the system currency symbol.
For example, if you are processing a report
containing values in Euros on a system where the
currency symbol is a pound sign (£), specify €.
CoolSpools will interpret data containing euro
signs as numeric data not text.
Spooled file decimal point
CVTSPLXLS only. In relation to CVTSPLXL, this is determined by the decimal point
character option that was specified when the report definition on which the report-to-
Excel map is dependent was created.
This element defines the decimal point that is used when printing numbers in the
report.
It is important that CoolSpools knows what decimal point symbol is used in the report
so that it can correctly identify columns of numbers as numeric data rather than
treating them as text.
Options are:
*JOB
The decimal point defined by the DECFMT
attribute of the current job is used in the report.
*SYSVAL
The decimal point defined by the QDECFMT
system value is used in the report.
Decimal_point
Specify the decimal point used in the report. For
example, if you are processing a report containing
numbers that have a comma as the decimal point
on a system where the normal decimal point is a
period (.), specify , (comma). CoolSpools will
interpret commas in numeric data as a decimal
point, not a thousands separator.
Spooled file 1000s separator
CVTSPLXLS only. In relation to CVTSPLXL, this is determined by the thousands
separator option that was specified when the report definition on which the report-to-
Excel map is dependent was created.
This element defines the thousands separator character that is used when printing
numbers in the report.
It is important that CoolSpools knows what thousands separator character is used in
the report so that it can correctly identify columns of numbers as numeric data rather
than treating them as text.
Options are:
56
CoolSpools Spool Converter User Guide V6R1
Page:
153
www.ariadnesoftware.co.uk
*JOB
The thousands separator character defined by the
DECFMT attribute of the current job is used in the
report.
*SYSVAL
The thousands separator character defined by the
QDECFMT system value is used in the report.
1000s_sep
Specify the thousands separator character used in
the report. For example, if you are processing a
report containing numbers that have a period as
the thousands separator character on a system
where the normal thousands separator character is
a comma (,), specify . (period). CoolSpools will
interpret periods in numeric data as a thousands
separator character, not a decimal point.
Spooled file date format
CVTSPLXLS only. In relation to CVTSPLXL, this is determined by the date format
option that was specified when the report definition on which the report-to-Excel map
is dependent was created. This element defines the date format that is used when
printing dates in the report.
It is important that CoolSpools knows what date format is used in the report so that it
can correctly identify dates and treat them as such.
Options are:
*JOB
The date format defined by the DATFMT attribute
of the current job is used in the report.
*SYSVAL
The date format defined by the QDATFMT system
value is used in the report.
*DMY
The date format used in the report is day-month-
year. CoolSpools will identify data in the report
which looks like a valid DMY date as a date (2-digit
or 4-digit year).
*MDY
The date format used in the report is month-day-
year. CoolSpools will identify data in the report
which looks like a valid MDY date as a date (2-digit
or 4-digit year).
*YMD
The date format used in the report is year-month-
day. CoolSpools will identify data in the report
which looks like a valid YMD date as a date (2-digit
or 4-digit year).
Spooled file date separator
CVTSPLXLS only. In relation to CVTSPLXL, this is determined by the date separator
option that was specified when the report definition on which the report-to-Excel map
is dependent was created. This element defines the date format that is used when
printing dates in the report.
This element defines the date separator that is used when printing dates in the
report.
VB.NET PDF: Basic SDK Concept of XDoc.PDF features can be integrated into your VB.NET project, such as annotation creating, deleting, modifying This class describes bookmarks in a PDF document.
pdf bookmark; how to bookmark a page in pdf document
52
CoolSpools Spool Converter User Guide V6R1
Page:
154
www.ariadnesoftware.co.uk
It is important that CoolSpools knows what date separator is used in the report so
that it can correctly identify dates and treat them as such.
Options are:
*JOB
The date separator defined by the DATFMT
attribute of the current job is used in the report.
*SYSVAL
The date separator defined by the QDATFMT
system value is used in the report.
date_sep
Specify the date separator character used in the
report. For example, if you are processing a report
containing dates that have a hyphen as the date
separator on a system where the normal date
separator character is a slash, specify - (hyphen).
Spooled file word for 'Page'
CVTSPLXLS only. In relation to CVTSPLXL, this information is irrelevant as page
headings are included or excluded dependent on what has been specified in the
Report-to-Excel map.
This element defines the word “Page” as it appears in the repo
rt.
When excluding page headings, CoolSpools attempts to take account of headings
which differ only by a change of page number. In order to do so, it looks for the word
defined on this element followed by a number and treats that text as a page number
and ignores it for the purposes of deciding whether a page heading is a new one or a
repetition of a previous one.
Options are:
*DFT
The word for “Page” is taken from the text of
message CVT0008 in message file CP_MSGF.
This is shipped in the English version of
CoolSpools as “Page”.
Please note that if you change the text in this
message file, you will need to change it back again
after applying PTFs or new versions.
Word_for_page
Specify the word for “Page” as it is used with page
numbers in the report. For example, if it is
abbreviated to “P.”, specify “P.” here. Similarly, if
you are processing a Spanish-language report,
you may need to specify Página.
Page breaks
CVTSPLXLS only.
Whether CoolSpools should insert page breaks in the Excel file at the end of each
page in the original spooled file.
Options are:
*NO
No page breaks will be inserted.
How to C#: Basic SDK Concept of XDoc.PDF for .NET annotation features can be integrated into your C# project, such as annotation creating, deleting, modifying This class describes bookmarks in a PDF document
bookmark pdf acrobat; bookmark pdf documents How to C#: Basic SDK Concept of XDoc.PowerPoint Conversely, conversion from PDF to PowerPoint (.PPTX C# project, such as annotation creating, deleting, modifying This class describes bookmarks in a PowerPoint
creating bookmarks in a pdf document; pdf bookmark editor
51
CoolSpools Spool Converter User Guide V6R1
Page:
155
www.ariadnesoftware.co.uk
*YES
A page break will be inserted in the Excel file after
the last row of each page in the original spooled
file.
Remove dot leaders
Whether CoolSpools should remove dot leaders from the output.
CVTSPLXLS only.
Dot leaders (such as in 'Customer number . . . . . : XXXXXX') are often used in
reported to connect data items with their associated labels, but in Excel output they
can make the document look messy, and can confuse the logic which determines
where to place column breaks.
Options are:
*NO
Dot leaders are not removed.
*YES
Dot leaders are removed (replaced with spaces).
Suppress underlining
CVTSPLXLS only.
Whether CoolSpools should remove consecutive underscores from the output.
Where underlining in the output is created using underscore characters (_), while this
can enhance the appearance of the printed page, it tends to detract from the
appearance of the data in an Excel file. CoolSpools will remove any consecutive
underscores it finds.
Options are:
*YES
Underscores are removed.
*NO
Underscores are not removed.
Column separator characters
CVTSPLXLS only.
When COLUMNOPT(*TOKEN) is specified, the values you select on this parameter
determine the way in which CoolSpools splits data in the spooled file up into columns
in the Excel or delimited file being created.
The default is *SPLF. This tells CoolSpools to break the spooled file data into
columns based on the way in which the data is organized in the spooled file.
Where the spooled file is created from an externally described printer file, this
method will probably give the best results, since the data in the spooled file is likely
to be organized so that each natural or logical item of data appears as a separately
identifiable element.
However, if the spooled file is created from an internally described printer file, or from
an application such as Query/400, it is likely that the data in the spooled file will be
presented to CoolSpools as a single, unstructured data block for each line of the
report. If this is the case then better results will probably be achieved by defining a
column separator character to control the splitting of the data in the report.
Every time CoolSpools encounters n consecutive characters of the type defined on
this parameter element, it will start a new column, n being the number defined for the
next element ("Number of column separators").
How to C#: Basic SDK Concept of XDoc.Word Conversely, conversion from PDF to Word (.docx) is C# project, such as annotation creating, deleting, modifying This class describes bookmarks in a Word document
pdf reader with bookmarks; add bookmarks to pdf How to C#: Basic SDK Concept of XDoc.Excel Conversely, conversion from PDF to Excel (.XLSX) is also C# project, such as annotation creating, deleting, modifying This class describes bookmarks in a Excel
excel print to pdf with bookmarks; excel pdf bookmarks
52
CoolSpools Spool Converter User Guide V6R1
Page:
156
www.ariadnesoftware.co.uk
For example, if you specify *BLANK for this element and 2 for the next, CoolSpools
will create a new column every time 2 or more consecutive blanks are found in the
spooled file.
If CoolSpools recognizes that the spooled file has been created from a file without
DDS or output by a Query/400 query, then it will automatically switch to using the
equivalent of *BLANK for "Column separator" and 2 for the "Number of column
separators" (see next).
Options are:
*SPLF
Split the data in the report based on the internal
organization of the data in the file.
*BLANK
The separator character is the blank (space)
character.
character-value The separator character to use to identify column
breaks.
Number of column separators
CVTSPLXLS only.
When COLUMNOPT(*TOKEN) is specified, the number of consecutive column
separator character that must appear before a column break occurs.
*NONE
This method is not used.
1-9
The number of consecutive characters required.
Excel date format
The formatting applied to dates in the Excel spreadsheet.
Using the information specified above concerning the format and separators used for
dates in the report, CoolSpools will attempt to identify data items in the report which
are dates. These will be output as standard Excel dates (a day count since the era)
in numeric cells but appropriate date formatting will be applied as specified here.
*MM
A two-digit numeric month will be used, e.g.
09/08/2010.
The date format will otherwise be determined by
your Excel settings and the regional settings of the
PC.
*MMM
A three-character month will be used, e.g. 09-Aug-
2010 or Aug-09-2010.
The date format will otherwise be determined by
your Excel settings and the regional settings of the
PC.
Excel worksheet name
The name that CoolSpools will give to the worksheet it creates in the Excel file.
If this name ends in a number (e.g. “Sheet1”), CoolSpools will g
enerate names for
subsequent worksheets by incrementing this number (e.g. “Sheet2”, “Sheet3”). If the
name specified does not end in a number, CoolSpools will generate the name of
53
CoolSpools Spool Converter User Guide V6R1
Page:
157
www.ariadnesoftware.co.uk
subsequent worksheets by appending a numeric suffix (e.g. if the sheet name
specified is “Invoices”, the next sheet will be “Invoices2” etc.).
CoolSpools variables may be specified on this parameter element.
Options are:
*DFT
The worksheet name is taken from the text of
message CVT0021 in message file CP_MSGF.
This is shipped in the English version of
CoolSpools as “Sheet1”.
Please note that if you change the text in this
message file, you will need to change it back again
after applying PTFs or new versions.
Sheet_name
Specify the name of the worksheet CoolSpools
should create.
Title
CVTSPLXLS only. In relation to CVTSPLXL, this information is specified on the
XLSPRPRTY parameter.
The title that should appear in the Excel file properties.
CoolSpools variables may be specified on this parameter element.
Options are:
*NONE
The file will have no title.
Title
The title that should appear.
Subject
CVTSPLXLS only. In relation to CVTSPLXL, this information is specified on the
XLSPRPRTY parameter.
The subject that should appear in the Excel file properties.
CoolSpools variables may be specified on this parameter element.
Options are:
*NONE
The file will have no subject.
Subject
The subject that should appear.
Author
CVTSPLXLS only. In relation to CVTSPLXL, this information is specified on the
XLSPRPRTY parameter.
The author’s name that sh
ould appear in the Excel file properties.
CoolSpools variables may be specified on this parameter element.
Options are:
*NONE
The file will have no author’s name.
*USRPRF
The user profile of the user running the
CoolSpools command will appear as the author
’s
name.
53
CoolSpools Spool Converter User Guide V6R1
Page:
158
www.ariadnesoftware.co.uk
*JOB
The name of the job running the CoolSpools
command will appear as the author’s name.
*QUALJOB
The fully qualified name of the job running the
CoolSpools command will appear as the author’s
name (i.e. job_number/user_profile/job_name).
Author
The author’s name that should appear.
Manager
CVTSPLXLS only. In relation to CVTSPLXL, this information is specified on the
XLSPRPRTY parameter.
The manager’s name that should appear in the Excel file properties.
CoolSpools variables may be specified on this parameter element.
Options are:
*NONE
The file will have no manager’s name.
Manager
The manager’s name that should appear.
Company
CVTSPLXLS only. In relation to CVTSPLXL, this information is specified on the
XLSPRPRTY parameter.
The company name that should appear in the Excel file properties.
CoolSpools variables may be specified on this parameter element.
Options are:
*NONE
The file will have no company name.
Company
The company name that should appear.
Keywords
CVTSPLXLS only. In relation to CVTSPLXL, this information is specified on the
XLSPRPRTY parameter.
The keywords that should appear in the Excel file properties.
CoolSpools variables may be specified on this parameter element.
Options are:
*NONE
The file will have no keywords
Keywords
The keywords that should appear.
Comments
CVTSPLXLS only. In relation to CVTSPLXL, this information is specified on the
XLSPRPRTY parameter.
The comments that should appear in the Excel file properties.
CoolSpools variables may be specified on this parameter element.
Options are:
*NONE
The file will have no comments
Comment
The comments that should appear.
52
CoolSpools Spool Converter User Guide V6R1
Page:
159
www.ariadnesoftware.co.uk
Category
CVTSPLXLS only. In relation to CVTSPLXL, this information is specified on the
XLSPRPRTY parameter.
The category that should appear in the Excel file properties.
CoolSpools variables may be specified on this parameter element.
Options are:
*NONE
The file will have no category
Category
The category that should appear.
Max rows per worksheet.
CVTSPLXL only.
The maximum number of records to write to a worksheet before starting a new
worksheet.
Options are:
*XLSVER
The limit is determined by the version of Excel:
*BIFF8 (*XLS):
65,535
*XLSX:
1,048,576
Max_rows
Specify the maximum number of rows. The value
must be less that the limit implied by the Excel
version selected.
Hide unused columns
CVTSPLXL only.
Whether unused columns are hidden or not
Options are:
*NO
Unused columns are not hidden and empty
columns appear to the right of the last used
column.
*YES
Unused columns are hidden and no empty
columns appear to the right of the last used
column.
Hide unused rows
Whether unused rows are hidden or not
Options are:
*NO
Unused rows are not hidden and empty rows
appear below the last used row in the last
worksheet.
*YES
Unused rows are hidden and empty rows no empty
rows appear below the last used row in the last
worksheet.
11
CoolSpools Spool Converter User Guide V6R1
Page:
160
www.ariadnesoftware.co.uk
Number of rows to freeze
How many rows should be included in a frozen pane at the top of each worksheet. A
frozen pane remains visible while the rest of the rows scroll.
Options are:
*NONE
No rows are frozen.
number_of_rows Specify the number of rows in the frozen pane.
Documents you may be interested
Documents you may be interested
