BI Publisher multi sheet output through rtf template

[Amar Phattepure]

Hi All,
I am working on such requirement where I need to display the output in multiple excel sheet (each sheet name will be different) using Oracle BI Publisher. I have tried with rtf template it works but only problem is to change the sheet name, currently its display the name like Sheet1, Sheet2,.. actually I want with with proper name of sheet like Employee details, Order Status...etc

Can some one suggest me the solution here...Appreciate your help

 

[Jitendra P]

Hi Amar,

I too am working on the same requirment's right now, but i am unable to find the solution to actually generate the multisheet output through rtf template.
Whereas on the maximum sites its given that it is not possible to generate such output through RTF. And It can be only generated through xslt template.
Can you please help me with your code or your way of accomplishing this task. Its on the priority for me right now. Any help would be appreciated.

Regards,
Jitendra