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

Bhargav Kollipara

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