My Oracle Support Banner

E1: XMLP: Creating XML Publisher Reports Using Excel Templates (Doc ID 1326347.1)

Last updated on JULY 25, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.97 and Prior and later
Information in this document applies to any platform.


An Excel template is a report layout that you design in Microsoft Excel for retrieving and formatting your enterprise reporting data in Excel. 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.

This document describes how XML/BI Publisher reports can be created using Excel Templates. It provides information on any special settings needed in EnterpriseOne to use Excel Templates.


 This document is intended for JDE report definition developers who wish to use excel templates to get excel outputs from Embedded BI Publisher Reports. 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Features of Excel Templates
 Limitations of Excel Templates
 Supported Output
 Desktop Tools
 Identifying Data Field Placeholders and Groups
 Use of Excel Defined Names
 About XDO_ Defined Names
 Using Native Excel Functions
 Building a Simple Template
 P95600 Add BI Publisher Object To Repository
 E1 UDC Codes needed for Excel Templates
 Sample E1 Excel Template created from R014021

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.