Re: [basex-talk] Available Integration with Apache POI for Excel Generation?

[Christian Grün]

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.

> 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_Bindings

[basex-talk] Available Integration with Apache POI for Excel Generation?

[Eliot Kimber]

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
LinkedIn | 
Twitter | 
YouTube | 
Facebook