44
Page:
114
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.
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/2005.
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-2005 or
Aug-09-2005.
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 generate 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
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 CS_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
The title that should appear in the Excel file properties.
CoolSpools variables may be specified on this parameter element.
Options are: