|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] XPath Against OpenXML and OpenOffice Spreadsheets?
Phil, Slav, ...thank you. I fail to believe that this is impossible
to do. I'll stay on it like a houndog, although I know I've been off
in the weeds for the last 4 hours... (embarrassing, but I want you all
to know that I am atleast trying)
I'll work on the sharedStrings.xml file (and related relationships to
map there) later. For now, my goal is to just return ANYTHING! I
guess the document() function can't get at the subfiles of OpenXML
documents? That must be why you were saying that it needs to take a
URL starting with zip:///.
I'm already doing this retrieval from Excel with ADO in VB. It's
super easy. I just really wanted to be an XML purist. I'm gonna try
that eXist out.
Here's where I am leaving off for the day...
-----------------------------------------------
c:\Saxon\bin>transform myxml.xml get-from-excel.xsl
<?xml version="1.0" encoding="UTF-8"?>
The values are
c:\Saxon\bin>
----------------------------------------------------
myxml.xml
<?xml version="1.0"?>
<excel-data>
<data>The values are</data>
</excel-data>
-----------------------------------------------------
get-from-excel.xsl
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema" exclude-result-prefixes="xs"
version="2.0" >
<xsl:variable name="sheet1"
select="document('Book1.xlsx/xl/worksheets/sheet1.xml')"/>
<xsl:template match="/data">
<xsl:result-document href="excel-data.xml">
<xsl:value-of select="."/>
<xsl:value-of select="$sheet1/*"/>
</xsl:result-document>
</xsl:template>
</xsl:stylesheet>
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|

Cart








