> Hi,
>
>
>
> I’m new to this mailing list and I already have a question J
>
>
>
> I have a form which pulls annual expense records from a database. The
> populated model instance looks like this:
>
>
>
> <expenses ex="565.00" xmlns:xs="http://www.w3.org/2001/XMLSchema"
> xmlns:p="http://www.orbeon.com/oxf/pipeline"
> xmlns:xi="http://www.w3.org/2001/XInclude"
> xmlns:oxf="http://www.orbeon.com/oxf/processors"
> xmlns:sql="http://orbeon.org/oxf/xml/sql">
>
>   <year>2009</year>
>
>   <wm_id>RWWM00011</wm_id>
>
>   <wm_name>cafekiwm_name>
>
>   <fb_id>RWFB00011fb_id>
>
>   <local_currency>RWF</local_currency>
>
>     <section name="CapEx Loan Expenses" currency="usd">
>
>       <item name="Interest" id="C9224C6A-50E1-4081-BCAA-EF80D0604960"
> advance="0">100.00
>
>       </item>
>
>       <item name="Principal" id="BEA45230-13CE-49A8-B25F-FD5FFF02329F"
> advance="0">100.00
>
>       </item>
>
>     </section>
>
>     <section name="Marketing / Credit Expenses" currency="usd">
>
>       <item name="Service" id="B915A8A0-651C-4008-9701-9230F8D6B9D9"
> advance="0">2000.00
>
>       </item>
>
>       <item name="Working Capital Fee Cost"
> id="B18A7788-10C6-4864-B462-792D988EF12F" advance="0">2000.00
>
>       </item>
>
>       <item name="Working Capital Interest Cost"
> id="39A5BE43-4E92-4ED8-AFA6-1DB6122FAC10" advance="0">2000.00
>
>       </item>
>
>     </section>
>
>     <section name="Wetmill Expenses" currency="rwf">
>
>          <!--AND SO ON -->
>
>       </section>
>
>     </section>
>
> </expenses>
>
>
>
> I’d like to the form user to be able to export this to an Excel spreadsheet,
> with totals for each section.
>
>
>
> What’s the best way to do this sort of thing in Orbeon forms?
>
>  I’ve seen in the Orbeon documentation that there was an Excel processor
> (POI library) but that this has been deprecated. There’s a reference to
> other internal documentation on Converters
> [http://www.orbeon.com/orbeon/doc/processors-converters#xls-converters] but
> Excel is not specifically mentioned.
>
>
>
> I’m guessing that the answer might be to use an XLST pipeline to convert the
> model instance into something compatible with the Microsoft XML Spreadsheet
> schema.
>
> If this is the case, can anyone suggest any resources / examples to help me
> on my way?
>
>
>
> Any help would be appreciated.
>
>
>
> Regards,
>
>     Alan.
>
>
>
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing
> list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>
>