Available Integration with Apache POI for Excel Generation?
Monday, 25 July 2022 · 4 messages · last reply 26 Jul 2022
EK
Eliot Kimber25 Jul 2022 20:29 #
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.com<https://www.servicenow.com>
LinkedIn<https://www.linkedin.com/company/servicenow> | Twitter<https://twitter.com/servicenow> | YouTube<https://www.youtube.com/user/servicenowinc> | Facebook<https://www.facebook.com/servicenow>
CG
Christian Grün26 Jul 2022 00:19 #
Hi Eliot,
We wrote lots of XQuery code for our customers to create, populate and update Excel files. Unfortunately, it’s not open source, at least for now.
Quoted text · Eliot Kimber · 1 line
> 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?
Maybe our Java bindings can be used for that [1]. With BaseX 9.6, the implementation was improved to pass through objects that would otherwise be converted back to XQuery values via the new
WRAPJAVA option.
Hope this helps,
Christian
[1] https://docs.basex.org/wiki/Java_BindingsTT
Tim Thompson26 Jul 2022 02:50 #
Resending to the list (forgot to reply all).
---------- Forwarded message ---------
Quoted text · Tim Thompson · 59 lines
From: Tim Thompson <timathom at 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 at 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 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 at 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.com <https://www.servicenow.com> > > LinkedIn <https://www.linkedin.com/company/servicenow> | Twitter > <https://twitter.com/servicenow> | YouTube > <https://www.youtube.com/user/servicenowinc> | Facebook > <https://www.facebook.com/servicenow> >
EK
Eliot Kimber26 Jul 2022 15:08 #
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.com<https://www.servicenow.com>
LinkedIn<https://www.linkedin.com/company/servicenow> | Twitter<https://twitter.com/servicenow> | YouTube<https://www.youtube.com/user/servicenowinc> | Facebook<https://www.facebook.com/servicenow>
Quoted text · BaseX-Talk · 32 lines
From: BaseX-Talk <basex-talk-bounces at mailman.uni-konstanz.de> on behalf of Tim Thompson <timathom at gmail.com> Date: Monday, July 25, 2022 at 5:50 PM To: BaseX <basex-talk at 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 at gmail.com<mailto:timathom at 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 at servicenow.com<mailto:eliot.kimber at 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-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 at servicenow.com<mailto:eliot.kimber at 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.com<https://www.servicenow.com> LinkedIn<https://urldefense.com/v3/__https:/www.linkedin.com/company/servicenow__;!!N4vogdjhuJM!Cz_w2CbhSe65FbmwfzIWxz1yBBNPeXPT0hSo5doXxTx23_7YUjWqLxLXmW_GG3vtM43a0DivKT1Bsd5GpBWvvQ$> | Twitter<https://urldefense.com/v3/__https:/twitter.com/servicenow__;!!N4vogdjhuJM!Cz_w2CbhSe65FbmwfzIWxz1yBBNPeXPT0hSo5doXxTx23_7YUjWqLxLXmW_GG3vtM43a0DivKT1Bsd6H31OtTQ$> | YouTube<https://urldefense.com/v3/__https:/www.youtube.com/user/servicenowinc__;!!N4vogdjhuJM!Cz_w2CbhSe65FbmwfzIWxz1yBBNPeXPT0hSo5doXxTx23_7YUjWqLxLXmW_GG3vtM43a0DivKT1Bsd5wxwZxhw$> | Facebook<https://urldefense.com/v3/__https:/www.facebook.com/servicenow__;!!N4vogdjhuJM!Cz_w2CbhSe65FbmwfzIWxz1yBBNPeXPT0hSo5doXxTx23_7YUjWqLxLXmW_GG3vtM43a0DivKT1Bsd5DmAsoDg$>
Written for BaseX 9.7. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery