How to save Table views as spreadsheet
Wednesday, 14 December 2016 · 4 messages · last reply 21 Dec 2016
K
kalamegham14 Dec 2016 01:10 #
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
HE
Hondros, Constantine (ELS-AMS)14 Dec 2016 09:15 #
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
Quoted text · kalamegham · 10 lines
-----Original Message----- From: basex-talk-bounces at mailman.uni-konstanz.de [mailto:basex-talk-bounces at mailman.uni-konstanz.de] On Behalf Of kalamegham at gmail.com Sent: 14 December 2016 00:10 To: basex-talk at 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.
CG
Hi,
Quoted text · kalamegham · 1 line
> I am new to BaseX
Welcome!
Quoted text · kalamegham · 1 line
> 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.
Quoted text · kalamegham · 1 line
> I apologize if this has been addresses in an earlier talk.
No problem.
Quoted text · kalamegham · 1 line
> 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 at mailman.uni-konstanz.de/ [2] https://www.google.de/search?q=site%3Amailman.uni-konstanz.de+csv
MG
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
Quoted text · Constantine (ELS-AMS) · 28 lines
On Wed, Dec 14, 2016 at 9:15 AM, Hondros, Constantine (ELS-AMS) <C.Hondros at 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 at mailman.uni-konstanz.de [mailto:basex-talk-bounces at mailman.uni-konstanz.de] On Behalf Of kalamegham at gmail.com > Sent: 14 December 2016 00:10 > To: basex-talk at 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
Written for BaseX 8.5. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery