Repeat Column Headers in BI Publisher Excel Templates

Dhanuka Chamal

Summary

Repeat Column Headers in BI Publisher Excel Templates

Content

Hello Everyone,

I have a requirement to repeat column headers in BI publisher excel templates when the data split into multiple sheets. Any help/ pointer is appreciated. Is it a limitation of the BI publisher excel templates.

Thanks,
Dhanuka

Version

20B

Sandeep S. Chauhan-Oracle

HI Dhanuka,

Generally this should work by default, column headers will repeat on all multiple sheets.

Can you elaborate more or you can share your template/excel file, i can have a look.

Regards,

Sandeep

Dhanuka Chamal

Hi Sandeep,

As you know the row limit of a .xls file is 65536 and after that data will split across multiple sheets. The column headers in my excel template (Person Number, Full Name, Company, etc.) will not be repeating in these sheets. Herein I have attached my excel template as you requested.

Regards,
Dhanuka

Lydia Jayasingh

Hi Dhanuka,

Were you able to figure out a solution?

Regards

Lydia

kollipara Bindu Bhargav

Hi Dhanuka,

I am also facing the same issue, if you found any solution for this please share it here.

Thanks,

kollipara. Bindu Bhargav.

ravikiran goda-Oracle

Please share the sample xml also

Hrishikesh-Oracle

Is there a solution available for this issue ?

Manish Maheshwari

Is there a solution available for this issue ?

Nikatfusion

Is there a solution available for this issue ?

User_8OVHZ

I am also facing same issue. Please share the solution if available.

Skolli-Oracle

Review the following document that has an example to split data based on row count:

Oracle Fusion BI Publisher: Need To Split Data Based On Row Count (Doc ID 2099308.1)

With this approach, the column header repeats when there is a split to multiple sheets based on the row count.