[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
|