Re: Re: XPath Against OpenXML and OpenOffice Spreadsh

To simplify things, you could 'Save As' XHTML and go from there.


On Wed, 2008-06-04 at 09:47 -0500, Ronnie Royston wrote:
> I would be delighted to see a working example.  Can someone please
> post a stylsheet that gets the value of cell A1 from Excel 2007 file
> named "Book1.xlsx" and assign it to <xsl:variable name="excel-value"
> as="xs:string*"/>?
> 
> This simple task is beyond my (and Google's) reach.
> 
> Ken Getz wrote a mind numbing 13 page article titled "Office Open XML
> Formats: Retrieving Excel 2007 Cell Values"
> http://msdn.microsoft.com/en-us/library/bb332058.aspx
> 
> The article opens up with an inspirational introduction, "Imagine that
> you need to retrieve information about a specific cell within an Excel
> workbook or set of workbooks. The ability to perform this operation
> without requiring you to load Excel 2007 and then load the workbooks,
> one after another, can be an incredible time saver, and the Office
> Open XML File Formats make this task possible. Working with the Office
> Open XML File Formats requires knowledge of the way Excel stores its
> content, the System.IO.Packaging API, and XML programming."
> 
> Then the "Code It" section follows, the rubber hits the road, and I
> experience a blow out. (note the Oxford Comma)
> 
> - Ronnie