[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

Re: [xsl] generating Office Open XML parts using xslt


Subject: Re: [xsl] generating Office Open XML parts using xslt
From: "Eliot Kimber ekimber@xxxxxxxxxxxx" <xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 25 Jul 2014 13:51:46 -0000

If you can use Java, the Apache POI library makes reading and writing MS
Office formats about as easy as it can be. I've successfully used the
libraries to read and write non-trivial Excel spreadsheets and also to
generate Powerpoint slides (although the current support for Powerpoint is
less complete than for Excel). It would be a significant development
effort to build equivalent infrastructure in XSLT and I would be loath to
take it on.

For powerpoint generation I used the technique of using an intermediate
XML format that abstracts slides and then Java code that transforms that
XML into Powerpoint using the POI library. That makes it possible to use
XSLT to generate the slide content but avoids having to deal with the
Office Open complexity in XSLT. The code is the The Slidinator project on
Github (https://github.com/drmacro/slidinator).

Cheers,

E.
bbbbb
Eliot Kimber, Owner
Contrext, LLC
http://contrext.com




On 7/25/14, 7:28 AM, "Nicolas BUONOMO nicolas.buonomo@xxxxxxxxxxx"
<xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx> wrote:

>Hi,
>
>You can also generating Open Document spreedsheets (xls) and then convert
>them to xlsx document with
>libreoffice for exemple.
>I think that generating Open Document Format is more easy than generating
>Office Open XML. I have do it in
>some simple case.
>
>Nicolas
>
>On 25/07/2014 03:02, Paul Tyson phtyson@xxxxxxxxxxxxx wrote:
>> Does anyone know of success stories in generating Office Open XML
>> artifacts using XSLT?
>>
>> (This is the "open" format used by Microsoft Office since 2007,
>> standardized in ISO/IEC 29500 and ECMA-376.)
>>
>> I am looking for pointers to solid documentation of namespaces and
>> package structure, particularly for SpreadsheetML (Microsoft's .xlsx
>> format) as used in Excel 2007.
>>
>> Thanks in advance,
>> --Paul
>>
>>
>
>--
>Nicolas BUONOMO
>CNAF - CNEDI RhC4ne Alpes
>DSI - Direction Fonctionnelle et Processus
>Relation avec les CollectivitC)s Territoriales
>TC)l : 0478636669 / 0677877811
>MC)l : nicolas.buonomo@xxxxxxxxxxx


Current Thread
Keywords