Hi Constantine,
Instead of with POI do it with standard XQuery and XSLT. Here's the gist (pun intended) of it https://gist.github.com/xokomola/59a590a423b86bb3ea809c1b03706c4b Haven't checked it for correctness but gives you an idea how it works.
--Marc
On Wed, Dec 14, 2016 at 9:15 AM, Hondros, Constantine (ELS-AMS) C.Hondros@elsevier.com wrote:
Hi there,
Unless I'm mistaken, I think the easiest thing to do is to serialise as CSV and import into something like Excel.
The CSV module can help you here: http://docs.basex.org/wiki/CSV_Module
Although thinking about it, perhaps other folks have tried wrapping a library like Apache POI (https://poi.apache.org/) so that spreadsheets can be created directly from XQuery?
Constantine
-----Original Message----- From: basex-talk-bounces@mailman.uni-konstanz.de [mailto:basex-talk-bounces@mailman.uni-konstanz.de] On Behalf Of kalamegham@gmail.com Sent: 14 December 2016 00:10 To: basex-talk@mailman.uni-konstanz.de Subject: [basex-talk] How to save Table views as spreadsheet
I am new to BaseX which I find as a powerful tool to work on xml data. The BaseX GUI is great. My question is: how can I save the Tables in the visualization as spreadsheet(s). I understand there are multiple views but it should be possible to save them as separate tables or tabs in a single spreadsheet.
I apologize if this has been addresses in an earlier talk. I would like to know if there is a way to quickly search the base-talk archives without having to look through them all (arranged by month).
Thanks! -R. Kalamegham
Elsevier B.V. Registered Office: Radarweg 29, 1043 NX Amsterdam, The Netherlands, Registration No. 33156677, Registered in The Netherlands.