Under the Get Started region, click Download BI Publisher Tools. The tools can be downloaded from the Home page of Oracle Business Intelligence Publisher or Oracle Business Intelligence Enterprise Edition, as follows:
#HOW DO DO DOTTED UNDERLINE IN EXCEL INSTALL#
The Template Builder for Excel is installed automatically when you install the Template Builder for Word. This facilitates design by enabling you to test and edit your template without having to upload it to the BI Publisher catalog first. Desktop ToolsīI Publisher provides a downloadable add-in to Excel that enables you to preview your template with sample data. To use some of the advanced features, the report designer will need knowledge of XSL and XSLT.Įxcel templates generate Excel binary (.xls) output only. The template file must be saved as Excel 97-2003 Workbook binary format (*.xls). Some features require the use of XSL and XSL Transformation (XSLT) specificationsįollowing are prerequisites for designing Excel templates: There is no tool to facilitate the markup of the template with BI Publisher tags all tags must be manually coded. If the template sheet includes images, when the data is split into multiple sheets, the images will show only on the first sheet. The following are limitations of Excel templates:įor reports that split the data into multiple sheets, images are not supported. Use native XSL functions in your data to manipulate it prior to rendering Split hierarchical data across multiple sheets and dynamically name the sheetsĬreate sheets of data that have master-detail relationships Features of Excel Templatesĭefine the structure for your data in Excel output Excel templates provide a set of special features for mapping data to worksheets and for performing additional processing to control how your data is output to Excel workbooks.
Using the Template Viewer to Debug a TemplateĪn Excel template is a report layout that you design in Microsoft Excel for retrieving and formatting your enterprise reporting data in Excel.Preprocessing the Data Using an XSL Transformation (XSLT) File.This chapter covers the following topics: Oracle Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher Creating Excel Templates Browser version script Skip Headers