I can respond to the rtf side of the question and partially to the rest. In SAS 9.1, you can modify a style element to use the PAGEOF syntax without having to burn a title statement. This gets around the problem of graphics not honoring the spec unles the NOGTITLE option is used.
I'll insert some text to show this technique. Notice the use of a "universal escape sequence". The escape alerts the process that a function is being used. The use of the universal escape means you do not have to set up the escapechar anytime you use this style.
This gives you the global usage you might use. I believe there is a restriction with PDF and graphics, but I can't answer with a lot of detail on that issue.
I know this is probably a stretch for SAS right now, but it would be great to have an ODS EXCEL option. I know you can achieve this with ods html file='filename.xls" or ods csv or with DDE, but all these methods seem clumsy.
A general thing: make all ODS destinations use the exact same syntax to achieve the same results.
If you are looking for something more specific: in the printer destinations, let titles print even when not the first thing on a page. Currently we have to use ODS PDF TEXT to get around this, and I dislike having to code all my titles twice, once for printer destinations and once for HTML.
I need to use ods tagsets.excelxpfor creating a report using an existing template.
The template contains all the header information in a required format.
What option should I use to output my dataset values into those specific cells (meant for values in the template)???
It would be better to start a new post than to tack a question onto a very different posting.
The bad news is that there is no option to do what you ask.
ODS TAGSETS.EXCELXP does not write to an existing Excel template (.xlt) file. Every time you run TAGSETS.EXCELXP, it creates a new, complete workbook. TAGSETS.EXCELXP will not add to an existing workbook; will not update specific rows/cells/columns in an existing workbook; will not update or add cells to an Excel template (.xlt) file. Every time ExcelXP runs it creates a new file, by overwriting the name specified in the FILE= option if it already exists or by creating a new file, if the name does not exist.
This is the kind of scenario (writing to an existing workbook or Excel template) that folks use DDE for.
You might try to replicate your header information using the TAGSETS.EXCELXP options to set PRINT headers and footers.