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 | Twitterhttps://twitter.com/servicenow | YouTubehttps://www.youtube.com/user/servicenowinc | Facebookhttps://www.facebook.com/servicenow
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-BaseXdbhttps://urldefense.com/v3/__https:/github.com/eliudmeza/OOXML-Library-XQuery-BaseXdb__;!!N4vogdjhuJM!Cz_w2CbhSe65FbmwfzIWxz1yBBNPeXPT0hSo5doXxTx23_7YUjWqLxLXmW_GG3vtM43a0DivKT1Bsd7PXGEHsA$
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.commailto: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 LinkedInhttps://urldefense.com/v3/__https:/www.linkedin.com/company/servicenow__;!!N4vogdjhuJM!Cz_w2CbhSe65FbmwfzIWxz1yBBNPeXPT0hSo5doXxTx23_7YUjWqLxLXmW_GG3vtM43a0DivKT1Bsd5GpBWvvQ$ | Twitterhttps://urldefense.com/v3/__https:/twitter.com/servicenow__;!!N4vogdjhuJM!Cz_w2CbhSe65FbmwfzIWxz1yBBNPeXPT0hSo5doXxTx23_7YUjWqLxLXmW_GG3vtM43a0DivKT1Bsd6H31OtTQ$ | YouTubehttps://urldefense.com/v3/__https:/www.youtube.com/user/servicenowinc__;!!N4vogdjhuJM!Cz_w2CbhSe65FbmwfzIWxz1yBBNPeXPT0hSo5doXxTx23_7YUjWqLxLXmW_GG3vtM43a0DivKT1Bsd5wxwZxhw$ | Facebookhttps://urldefense.com/v3/__https:/www.facebook.com/servicenow__;!!N4vogdjhuJM!Cz_w2CbhSe65FbmwfzIWxz1yBBNPeXPT0hSo5doXxTx23_7YUjWqLxLXmW_GG3vtM43a0DivKT1Bsd5DmAsoDg$