Change excel sheetname ( BI Publisher - Excel template 12.2.1.3)
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'
|
|---|
Column 'B'
<?replace(.//DEPT_NAME,"ABC","XYZ")?>
<?replace(..//DEPT_NAME,"ABC","XYZ")?>
Single quote same error. <?replace(.//DEPT_NAME,'ABC','XYZ')?>
Tried all three commands above.
0