Change excel sheetname ( BI Publisher - Excel template 12.2.1.3)

User_IPZH9

Hi,

We have a multi-sheet excel template report which is working fine. There is a requirement to change the sheet name at run time.

Sheet name is based on department name. However business wants to change one department name sheet to a specific name.

Tried using replace command it's not working.

Error:

org.xml.sax.SAXException: Parse Error in replace function.
oracle.xdo11g.xpath.XPathException: Parse Error in replace function.

Column 'A'

XDO_SHEET_NAME_?

Column 'B'

<?replace(.//DEPT_NAME,"ABC","XYZ")?>

<?replace(..//DEPT_NAME,"ABC","XYZ")?>

Tried both commands above.

thanks for your inputs.

User_IPZH9

Single quote same error. <?replace(.//DEPT_NAME,'ABC','XYZ')?>

thanks

Kevin M-Oracle

Change the name (replace) in the data generation, then there is no need to modify the layout.

Rgds,

Kevin

User_IPZH9

Hi Kevin,

Thanks for the quick response. How ever we need only the sheet name changed. The data in the sheet should remain as it is. Tried XSLT no luck. Is there a way to transform in XDO_METADATA.

XDO_SHEET_NAME_? <?./DEPT_NAME?>

Check ./DEPT_NAME for 'ABC' and change to 'XYZ' only in the sheet name.

thanks for your inputs.

User_IPZH9

Yes. Trying with additional sheet_name element in the xml data model.

thanks

-Rao