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
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.
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.
-- --Marc
Hi,
I am new to BaseX
Welcome!
How can I save the Tables in the visualization as spreadsheet(s).
There is currently no way to export the contents of the table visualization as CSV. As Constantine indicated, you can use XQuery and the CSV Module instead. Once you have written such a script, it should be easily adaptable to arbitrary contents.
I apologize if this has been addresses in an earlier talk.
No problem.
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).
You can either use the Mail Archive [1] or simply use Google and restrict your search to our mailing list [2]. If you look for "BaseX" and other keywords, you will also find hits from other sources like StackOverflow. Hope this helps, Christian [1] https://www.mail-archive.com/basex-talk@mailman.uni-konstanz.de/ [2] https://www.google.de/search?q=site%3Amailman.uni-konstanz.de+csv
participants (4)
-
Christian Grün -
Hondros, Constantine (ELS-AMS) -
kalamegham＠gmail.com -
Marc van Grootel