Hi guys,
are there any ideas how to convert excel's xlsx (not xls) files to xml with XQuery or to use a Java library which can be imported? It looks like BaseX has no internal functions as for instance MarkLogic.
Any ideas or example implementations to do that in XQuery or Java?
Best, Florian
Hello Florian,
xlsx is just a zip file containing many xml files. you can simply unzip the xlsx (e.g. by using the BaseX zip module), modify the xml files inside using standard XQuery and rezip it again as xslx.
Cheers Dirk
On 04/06/2016 12:18 PM, Florian Eckey wrote:
Hi guys,
are there any ideas how to convert excel's xlsx (not xls) files to xml with XQuery or to use a Java library which can be imported? It looks like BaseX has no internal functions as for instance MarkLogic.
Any ideas or example implementations to do that in XQuery or Java?
Best, Florian
Florian,
The joined module transforms an excel file (saved in XML spreadsheet 2003, and imported in the IN db) into a XML file.
I hope it could help.
André
Le 6 avr. 2016 à 12:26, Dirk Kirsten dk@basex.org a écrit :
Hello Florian,
xlsx is just a zip file containing many xml files. you can simply unzip the xlsx (e.g. by using the BaseX zip module), modify the xml files inside using standard XQuery and rezip it again as xslx.
Cheers Dirk
On 04/06/2016 12:18 PM, Florian Eckey wrote:
Hi guys,
are there any ideas how to convert excel's xlsx (not xls) files to xml with XQuery or to use a Java library which can be imported? It looks like BaseX has no internal functions as for instance MarkLogic.
Any ideas or example implementations to do that in XQuery or Java?
Best, Florian
-- Dirk Kirsten, BaseX GmbH, http://basexgmbh.de |-- Firmensitz: Blarerstrasse 56, 78462 Konstanz |-- Registergericht Freiburg, HRB: 708285, Geschäftsführer: | Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle `-- Phone: 0049 7531 91 68 276, Fax: 0049 7531 20 05 22
Hi Florian,
We frequently use XQuery to read and update Excel files in our commercial projects. We haven’t made the code open source yet, though. As Dirk indicated, office files are unzipped, modified and written back, using e.g. our Archive Module and XQuery Update.
Hope this helps, Christian
On Wed, Apr 6, 2016 at 12:18 PM, Florian Eckey florian.eckey@googlemail.com wrote:
Hi guys,
are there any ideas how to convert excel's xlsx (not xls) files to xml with XQuery or to use a Java library which can be imported? It looks like BaseX has no internal functions as for instance MarkLogic.
Any ideas or example implementations to do that in XQuery or Java?
Best, Florian
basex-talk@mailman.uni-konstanz.de
-
Andre Bovy -
Christian Grün -
Dirk Kirsten -
Florian Eckey