RE: [docbook-apps] export from MS Excel to DocBook?

["Kerry, Richard" <richard.kerry@atos.net>]

Not knowing about the xlsx (sic) unpacking facility in Saxon, and having had no success trying to automate Excel internally, I've recently written a simple C++ program to take an Excel spreadsheet file and convert it to XML.  From there I'm using Xsl to generate the Xml I really want.

As it's a program I've written for work I can't publish it, though it is really quite simple.  Access Excel using COM.  Scan all worksheets, scan all rows, scan all columns, and write the text in the cells to Xml using Msxml.  Took about an afternoon to get it working.

Maybe now I'll see if I can get anything useful from the xlsx file directly using Saxon....

Unhelpfully,
Richard.




> -----Original Message-----
> From: Jirka Kosek [mailto:jirka@kosek.cz] 
> Sent: 16 August 2012 09:02
> To: Robert.Buergel@bmw.de
> Cc: docbook-apps@lists.oasis-open.org
> Subject: Re: [docbook-apps] export from MS Excel to DocBook?
> 
> On 16.8.2012 9:23, Robert.Buergel@bmw.de wrote:
> 
> > Has anybody any experience with this? Any pointers?
> 
> XSLT 2.0 has powerfull grouping instruction xsl:for-each-group. With
> that instruction and Excel file saved as .xslx it's fairly easy to
> produce output you want. Also Saxon9 (XSLT 2.0 
> implementation) can read
> directly content of .xsls files there is no need to unpack them first.
> Simply use something like
> 
> doc('jar:table.xslx!!/_rels/.rels')
> 
> to access parts of XSLX file.
> 
> 				Jirka
> 
> -- 
> ------------------------------------------------------------------
>   Jirka Kosek      e-mail: jirka@kosek.cz      http://xmlguru.cz
> ------------------------------------------------------------------
>        Professional XML consulting and training services
>   DocBook customization, custom XSLT/XSL-FO document processing
> ------------------------------------------------------------------
>  OASIS DocBook TC member, W3C Invited Expert, ISO JTC1/SC34 member
> ------------------------------------------------------------------
> 
>