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.
Procedure: How to Create an Excel Template for Project-Based Development
a blank worksheet to a workbook in Microsoft Excel. This blank worksheet
will contain the WebFOCUS report.
the workbook as a Web archive (.mht extension) file on your WebFOCUS
Reporting Server application directory.
your WebFOCUS procedure in the Projects area of Developer Studio.
Painter, click Format from the Report menu.
that Excel 2007 (XSLX), Excel
2000 (EXL2K), Excel 2007 Formula (XLSX FORMULA),
2000 Formula (EXL2K FORMULA), Excel 2000
PivotTable (EXL2K PIVOT), Excel 97 (EXL97),
or User (Excel) is selected as the output format.
template to activate the Excel template options.
the template file (Workbook Name) and the Worksheet to populate.
The Worksheet to populate is the number of the worksheet in the
workbook. For example, if you have five worksheets in your workbook
and you designated the first worksheet for the WebFOCUS report,
then you would enter 1.
- In order for your
workbook to appear in the Workbook Name drop-down list, it must
be in your WebFOCUS Reporting Server application directory.
- If you use the Excel
2007 output format, you will be able to choose templates with the
.xltx, .xlsx, .xltm, and .xlsm formats. For all other Excel output
formats, you will only be able to use templates with the .xltx format.
Click OK in
the Report Options dialog box.
and run your report.
Reference: Notes on Saving an Excel File as a Web Archive
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.
your template file is not a true Web archive file, you receive the
(FOC3290) EXL2K: Template file is not a valid WebArchive file
verify that an .mht file is a valid Web archive, open the file in
Notepad. The second line of the file should read:
non-Web archive file says Worksheet instead