How to: |
The following Excel file types can be used as template files to generate EXL07 workbooks.
|
Template File Type |
Output Workbook Generated |
|---|---|
|
Template (.xltx) |
Workbook (.xlsx) |
|
Macro-Enabled Template (.xltm) |
Macro-Enabled Workbook (.xlsm) |
|
Workbook (.xlsx) |
Workbook (.xlsx) |
|
Macro-Enabled Workbook (.xlsm) |
Macro-Enabled Workbook (.xlsm) |
To support the expanded template files types, the template file name attribute has been enhanced to allow the inclusion of the file extension. If no extension is specified within the template name, the file extension will default to .XLTX.
ON TABLE PCHOLD FORMAT EXL07 TEMPLATE template_name SHEETNUMBER n
where:
Is the name of the Excel template file (workbook), including the file name and extension, residing on the WebFOCUS Reporting Server application directory search path. For example, IPOLICY.XLTX, PRINTSHEETS.XLTM, or DASHBOARD.XLSM. If the extension is not provided, it defaults to .XLTX.
Is the number of the Excel worksheet being replaced in the template file (workbook).
| WebFOCUS |