Available Integration with Apache POI for Excel Generation?
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>
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
participants (2)
-
Christian Grün -
Eliot Kimber