6 Creating Excel Templates

This chapter describes creating report templates for BI Publisher in Microsoft Excel using the Template Builder for Excel.

This chapter includes the following sections:

• Introduction to Excel Templates

• Understanding Mappings Between the Template and the Data

• Using the Template Builder for Excel

• Building a Basic Template Using the Template Builder

• Formatting Dates

• Understanding Excel Template Concepts

• Using Advanced BI Publisher Functions

• Preprocessing the Data Using an XSL Transformation (XSLT) File

• Using the Template Viewer to Debug a Template