XSL output to EXCEL
BPMar 16 2011 — edited Mar 17 2011Currently, we have a XSL file which transforms a XML to Excel spreadsheet.
Both Data Template and XSL Template works fine EBS 11i. (We are able to generate a excel report via Concurent Manager)
Now, I've loaded and executed the XSL and XML (with Data) in JDeveloper (11.1.1.4.0) with proper Debug/Runtime Launch setting.
My Qustions are:
1. JDeveloper generated a Excel file, but I am not able to open the xls file with Excel.
2. Is there a way to default JDeveloper to direct the output to Excel?
Thanks.
A portion of the XSL Template:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:msxsl="urn:schemas-microsoft-com:xslt"
xmlns:user="urn:my-scripts"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" >
:
:
: