XSL Splitting the Data by Count of Rows not Splitting Data Into Multiple Excel Sheets (Doc ID 2451648.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

On 12c version, Enterprise : Administration

ACTUAL BEHAVIOR 
Creating a preprocessing XSL template to split data by row count is not working for Excel Templates per the documentation.

There is the following section in the Report Designers Guide that provide a sample on splitting the data by rowcount into multiple Excel Sheets. For instance, from the 12.2.1.2 guide, follow the section "Splitting the Data by Count of Rows":

Report Designers Guide > Creating Excel Templates > Preprocessing the Data Using an XSL Transformation (XSLT) File

However, when following the direction and creating the XSL sheet, it is not working. When generating the report and saving the Excel .xls file, the file size is 0 bytes. The above code is needed in order to avoid an issue with Excel files exceeding 65k rows, which is a limitation with Excel 2003 format (xls) which BI Publisher outputs from Excel Template files. Newer Excel 2007 format (xlsx) does not have this limitation, but BI Publisher does not output to xlsx from Excel Templates. You can output to xlsx from a RTF template only.

EXPECTED BEHAVIOR
The data should be splitted into multiple Excel sheets as documented.

Steps to reproduce the problem:
1. Create a Excel Template.
2. Create a XSL file per the documentation above.
3. Run the report and save the Excel to a file.

Business Impact
Unable to split the data into multiple sheets.

Cause

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