EXL2K TEMPLATE

Format: EXL2K TEMPLATE (.xls)

Description: Scheduled output opens within Excel 2002 or higher.

Excel templates that are populated with data from scheduled output.

Suggested Uses: Email, Report Library.

Considerations:

• When the format of an EXL2K TEMPLATE report is not overridden in the schedule, the Report Library will display EXL2K as the format.
• The scheduled procedure must contain a PCHOLD statement, such as the following:

  ON TABLE PCHOLD FORMAT EXL2K TEMPLATE templatename SHEETNUMBER sheetnumber

• Must be using Windows XP or Windows 2003 or higher.
• Microsoft Excel 2002 or higher must be installed.
• The format is ASCII.
• All EXL2K output with an .mht extension is dynamically changed to .xls for email or FTP distribution. You must edit your web server MIME table so that the .xls extension is ASCII application data, instead of binary.
• Bursting is supported.