How to name the excel sheet in rtf template

Hello All,

I am creating multisheet excel output using RTF template.

Can anyone please assist how to name the Excel sheet in RTF Template?

 

Hi ,

As I know we can't get multi sheet Excel output using RTF Template. We can achieve it by using Excel Template. Please refer the below link.

http://docs.oracle.com/cd/E10415_01/doc/bi.1013/e14667/create_excel_tmpl.htm#ext_multsheets

In that link refer the following one

3.5.1.1 Splitting the Report into Multiple Sheets

Regards
Sambasiva Reddy.K

 

We can create multi sheet excel output using RTF Template. If you just CTRL+Enter then the output will be split to 2 sheets.But I am not getting how to name the sheets.

 

Oh!! Great.. Thank you..
But where to do CTRL+Enter for to get the multisheet output? plz explain us...

Regards
Sambasiva Reddy.K

 

Open your RTF template and do CTRL+Enter the output will be in 2 sheets . I have created 8 sheets report. but not getting how to rename those sheets...

 

Hello RG Hegde,

You can specify a sheet name following this note:

http://docs.oracle.com/cd/E28280_01/bi.1111/e22254/create_rtf_tmpl.htm#BIPRD3325

Regards

 

Can you please share sample RTF file for multi Sheet output.