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