[Solved - sort of] Re: Converting XML files to Libreoffice Calc
On Thu, 1 Dec 2016, stan wrote: On Thu, 1 Dec 2016 12:48:57 -0500 (EST) Max Pyziur wrote: Greetings, A data site provides downloadable data in xml format; the header reads: http://www.w3.org/TR/REC-html40";> 2016-12-01T15:08:55Z 1 It imports seamlessly into MS Excel. I'm flummoxed as to how to do the same in Libreoffice. I've searched for LibreOffice XML filters, but I haven't come across anything yet. Much thanks for any guidence. I don't know the answer to your question, and didn't find any direct answer. But this user had the opposite problem just three years ago. Maybe you can use his template to solve your problem? http://stackoverflow.com/questions/19114932/exporting-complex-html-table-to-excel Much thanks for all of the help. I found an intermediate solution that works relatively well - a set of python command line utilities: https://github.com/knadh/xmlutils.py For an xml file that is a table, xmltable2csv converts the files to csv, and from there things fall into place. Importing into Libreoffice would be better, but save that for another day. Thank you again, MP ___ users mailing list -- users@lists.fedoraproject.org To unsubscribe send an email to users-le...@lists.fedoraproject.org
Re: Converting XML files to Libreoffice Calc
Am 01.12.2016 um 18:48 schrieb Max Pyziur: Greetings, A data site provides downloadable data in xml format; the header reads: xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40";> 2016-12-01T15:08:55Z 1 It imports seamlessly into MS Excel. I'm flummoxed as to how to do the same in Libreoffice. I've searched for LibreOffice XML filters, but I haven't come across anything yet. Much thanks for any guidence. Max Pyziur p...@brama.com In LibreOffice spreadsheet you'll find in the Data menu: "XML Source" - perhaps this can do what you want? See: https://wiki.documentfoundation.org/Development/Calc/XMLSource --- Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft. https://www.avast.com/antivirus ___ users mailing list -- users@lists.fedoraproject.org To unsubscribe send an email to users-le...@lists.fedoraproject.org
Re: Converting XML files to Libreoffice Calc
On 12/01/2016 09:48 AM, Max Pyziur wrote: A data site provides downloadable data in xml format; the header reads: http://www.w3.org/TR/REC-html40";> 2016-12-01T15:08:55Z 1 It imports seamlessly into MS Excel. I'm flummoxed as to how to do the same in Libreoffice. I've searched for LibreOffice XML filters, but I haven't come across anything yet. I haven't seen such a thing before. Can you provide a sample for testing? ___ users mailing list -- users@lists.fedoraproject.org To unsubscribe send an email to users-le...@lists.fedoraproject.org
Re: Converting XML files to Libreoffice Calc
On Thu, 1 Dec 2016 12:48:57 -0500 (EST) Max Pyziur wrote: > Greetings, > > A data site provides downloadable data in xml format; the header > reads: > > xmlns:o="urn:schemas-microsoft-com:office:office" > xmlns:x="urn:schemas-microsoft-com:office:excel" > xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" > xmlns:html="http://www.w3.org/TR/REC-html40";> > > 2016-12-01T15:08:55Z > 1 > > > > > > It imports seamlessly into MS Excel. I'm flummoxed as to how to do > the same in Libreoffice. I've searched for LibreOffice XML filters, > but I haven't come across anything yet. > > Much thanks for any guidence. I don't know the answer to your question, and didn't find any direct answer. But this user had the opposite problem just three years ago. Maybe you can use his template to solve your problem? http://stackoverflow.com/questions/19114932/exporting-complex-html-table-to-excel ___ users mailing list -- users@lists.fedoraproject.org To unsubscribe send an email to users-le...@lists.fedoraproject.org