Excel Templates in BI Publisher

In this blog, I'll explain how to develop templates using Microsoft excel.

In general all the templates are developed in RTF or PDF or xls-fo.

If you need the out put in excel, we can make a RTF template and choose the output as excel. But there are some limitations. For example default print layout can not be set for the out put.

Where as, the templates developed using MS-excel can be formatted as required and uploaded to XML Publisher.

So to use the excel template for XML reports, we need to know how to reference the xml tags in excel.

RTF EXCEL

------- ----------

XDO_?emp_name?

keeping this tag inside a cell will not work. we need to use the tag in the name box.

For groups

---------------------------------------------------

XDO_GROUP_?employee?

to apply the group for some cells, all the sells that falls into this group need to be selected and then name it with the above tag.

Additional Documentation:
http://docs.oracle.com/cd/E21764_01/bi.1111/e13881/T527073T571887.htm