How to: Reference: |
Report Painter provides Microsoft® Excel templates that are populated with data from WebFOCUS.
With this feature, you can integrate WebFOCUS with complex Excel workbooks that may contain macros, graphs, or Visual Basic applications. You can also supply ad hoc and end users with more advanced Excel functionality, such as filters, subtotals, page and print settings, and so on. This feature also provides you with more advanced styling options for Excel-based reports.
Note: You must have Excel 2002 or higher to use this feature.
Note:
Excel saves template files that contain only a single worksheet in its standard HTML file format rather than a Web archive (even if you select the .mht format in the Save-As dialog box, and it saves the file with a suffix of .mht). To ensure that you get a true Web archive file, your workbook must have at least two sheets, each of which contains content. The content can be a single blank in a single cell.
If your template file is not a true Web archive file, you receive the following message:
(FOC3290) EXL2K: Template file is not a valid WebArchive file
To verify that an .mht file is a valid Web archive, open the file in Notepad. The second line of the file should read:
X-Document-Type: Workbook
A non-Web archive file says Worksheet instead of Workbook.
WebFOCUS |