[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 <pyz(a)brama.com> wrote:
> Greetings,
>
> A data site provides downloadable data in xml format; the header
> reads: <?xml version="1.0"?>
> <?mso-application progid="Excel.Sheet"?>
> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
> 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">
> <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
> <Created>2016-12-01T15:08:55Z</Created>
> <Version>1</Version>
> </DocumentProperties>
> <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"/>
> <Styles>
>
>
> 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-...
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