Perhaps you have already seen: https://gist.github.com/joewiz/ed624a43cb6f9e15cc44b6e30553ad5e I think it might be for ExistDB
On Wed, Jul 27, 2022 at 6:00 PM basex-talk-request@mailman.uni-konstanz.de wrote:
Send BaseX-Talk mailing list submissions to basex-talk@mailman.uni-konstanz.de
To subscribe or unsubscribe via the World Wide Web, visit https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk or, via email, send a message with subject or body 'help' to basex-talk-request@mailman.uni-konstanz.de
You can reach the person managing the list at basex-talk-owner@mailman.uni-konstanz.de
When replying, please edit your Subject line so it is more specific than "Re: Contents of BaseX-Talk digest..."
Today's Topics:
- Re: Fwd: Available Integration with Apache POI for Excel Generation? (Eliot Kimber)
- BaseX YAML Parser? (Eliot Kimber)
- Re: BaseX YAML Parser? (Marco Lettere)
- Re: BaseX YAML Parser? (Martin Honnen)
- Re: BaseX YAML Parser? (Hans-Juergen Rennau)
- Re: BaseX YAML Parser? (?yvind Gjesdal)
- Re: BaseX YAML Parser? (Imsieke, Gerrit, le-tex)
- Re: BaseX YAML Parser? (Eliot Kimber)
Message: 1 Date: Tue, 26 Jul 2022 13:08:24 +0000 From: Eliot Kimber eliot.kimber@servicenow.com To: BaseX basex-talk@mailman.uni-konstanz.de Subject: Re: [basex-talk] Fwd: Available Integration with Apache POI for Excel Generation? Message-ID: < SN4PR0801MB77576BAD6B0F077D6727731CF1949@SN4PR0801MB7757.namprd08.prod.outlook.com
Content-Type: text/plain; charset="windows-1252"
Tim,
Thanks for the pointer?that?s not quite what I was looking for.
What I have in mind is adding functions that let you read and write Excel spreadsheets using the POI API, which is much easier to use than interacting directly with the OOXML under the covers (Excel uses a lot of indirection and data normalization to minimize file size that makes operating on the raw XML really challenging).
I fully understand that Christian?s team have done this kind of work for hire and are not keen (or even contractually allowed) to give it away. It?s valuable stuff.
But I had to ask?
Cheers,
E.
Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.comhttps://www.servicenow.com LinkedInhttps://www.linkedin.com/company/servicenow | Twitter< https://twitter.com/servicenow%3E | YouTube< https://www.youtube.com/user/servicenowinc%3E | Facebook< https://www.facebook.com/servicenow%3E
From: BaseX-Talk basex-talk-bounces@mailman.uni-konstanz.de on behalf of Tim Thompson timathom@gmail.com Date: Monday, July 25, 2022 at 5:50 PM To: BaseX basex-talk@mailman.uni-konstanz.de Subject: [basex-talk] Fwd: Available Integration with Apache POI for Excel Generation? [External Email]
Resending to the list (forgot to reply all).
---------- Forwarded message --------- From: Tim Thompson <timathom@gmail.commailto:timathom@gmail.com> Date: Mon, Jul 25, 2022 at 5:04 PM Subject: Re: [basex-talk] Available Integration with Apache POI for Excel Generation? To: Eliot Kimber <eliot.kimber@servicenow.commailto: eliot.kimber@servicenow.com>
Hi, Eliot,
I'm not aware of any integration with Apache POI (which would be great), but here's a project--it seems unfinished, but may be enough to get started with?
https://github.com/eliudmeza/OOXML-Library-XQuery-BaseXdb< https://urldefense.com/v3/__https:/github.com/eliudmeza/OOXML-Library-XQuery...
All best, Tim
-- Tim A. Thompson (he, him) Librarian for Applied Metadata Research Yale University Library
On Mon, Jul 25, 2022 at 2:29 PM Eliot Kimber <eliot.kimber@servicenow.com mailto:eliot.kimber@servicenow.com> wrote: I tried searching for ?BaseX Excel generation? but it didn?t get me farther than a reference to the CSV module, which of course I am familiar with.
I need to add the ability to generate non-trivial Excel spreadsheets, which I know how to do using the Apache POI library, but being lazy I was hoping somebody had already done it in a shareable form.
So my question: Does anyone have or know of a shareable integration of Apache POI with BaseX for generating Excel spreadsheets or some other Excel-generation solution that is not just downloading CSV files?
Thanks,
E. _____________________________________________ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.comhttps://www.servicenow.com LinkedIn< https://urldefense.com/v3/__https:/www.linkedin.com/company/servicenow__;!!N... | Twitter< https://urldefense.com/v3/__https:/twitter.com/servicenow__;!!N4vogdjhuJM!Cz... | YouTube< https://urldefense.com/v3/__https:/www.youtube.com/user/servicenowinc__;!!N4... | Facebook< https://urldefense.com/v3/__https:/www.facebook.com/servicenow__;!!N4vogdjhu...