Excel's Freeze Pane Property in RTF template for XML Publisher Report

sameer ashturkar

Summary

Excel's Freeze Pane Property in RTF template for XML Publisher Report

Content

Hi all,

I have created RTF template and it's output type is Excel.
I want to apply Freeze Pane Property of Excel with rtf template so that it can be applied to Excel Output.

Please help me on this in case anybody worked on kind of such requirement in past.

 

 

Regards,

Samer Ashturkar.

 

 

Skolli-Oracle

BI Publisher do not format the data sent to the Excel.
Please try building the report in Excel Template instead of rtf:

          https://docs.oracle.com/middleware/11119/bip/BIPRD/create_excel_tmpl.htm

Note - Excel Template can only output the report in .xls, data or csv. For other output types, we need to use rtf format.

sameer ashturkar

Hey Sudhir,

I did that through the excel but was looking it can be possible through RTF or not.
Because through RTF template we can handle other cosmetic attributes very effectively.

Thanks for confirming on this.!

 

Regards,

Sameer Ashturkar

Skolli-Oracle

https://docs.oracle.com/middleware/11119/bip/BIPRD/create_excel_tmpl.htm

An Excel template is a report layout designed in Microsoft Excel for formatting your enterprise reporting data in Excel spreadsheets. Excel templates provide a set of special features for mapping data to worksheets and for performing additional processing to control how the data is output to Excel workbooks.

RTF do not format the data sent to Excel.