Converting XML files to Libreoffice Calc

[Max Pyziur]

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.

Max Pyziur
pyz(a)brama.com

[stan]

On Thu, 1 Dec 2016 12:48:57 -0500 (EST)
Max Pyziur <pyz(a)brama.com&gt; 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-...

[Solved - sort of] Re: Converting XML files to Libreoffice Calc

[Max Pyziur]

On Thu, 1 Dec 2016, stan wrote:

>  On Thu, 1 Dec 2016 12:48:57 -0500 (EST)
>  Max Pyziur <pyz(a)brama.com&gt; 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

[Samuel Sieb]

On 12/01/2016 09:48 AM, Max Pyziur wrote:
>  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.
>  
I haven't seen such a thing before.  Can you provide a sample for testing?

[Klaus-Peter Schrage]

Am 01.12.2016 um 18:48 schrieb Max Pyziur:
>  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.
>
>  Max Pyziur
>  pyz(a)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