[Solved] Export xml file to spreadsheet
[Solved] Export xml file to spreadsheet
I have not been able to export to a spreadsheet - i've tried all of the options, comma etc. Can anyone help please? I am on windows 10 and have just installed your latest version. Thanks, Linda
Last edited by robleyd on Thu Jan 18, 2018 12:56 pm, edited 1 time in total.
Reason: Tagged [Solved] [robleyd, Moderator]
Reason: Tagged [Solved] [robleyd, Moderator]
openoffice 4.1.5 on windows 10
Re: export xml file to spreadsheet
It would help us help you if you could be a little more informative about exactly what you are trying to achieve. For instance "export to a spreadsheet" - from what application are you trying to export? You mention XML but when you say "tried all of the options, comma etc" it seems you may be trying to export in delimited format, perhaps CSV?
Please tell us exactly what steps you are taking, and with what software.
Please tell us exactly what steps you are taking, and with what software.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
Re: Export xml file to spreadsheet
I guess, you want to read XML data into a spreadsheet, which we call import, and then save the spreadsheet as a spreadsheet document.
There are thousands of different XML flavours. All the details depend on the application which generated the XML in question.
If you open the XML with a text editor or with an internet browser, you might see some kind of declaration (meta information) on top which should help us to understand what you actually try to open.
There are thousands of different XML flavours. All the details depend on the application which generated the XML in question.
If you open the XML with a text editor or with an internet browser, you might see some kind of declaration (meta information) on top which should help us to understand what you actually try to open.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Export xml file to spreadsheet
Thanks for your help. I have found a Playlist Converter app that has done it
Thanks again
Thanks again
openoffice 4.1.5 on windows 10
Re: [Solved] Export xml file to spreadsheet
I guess the actual issue here will remain a mystery forever
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
Re: [Solved] Export xml file to spreadsheet
I managed to read the xml data by changing it to tab to separate the columns. Thanks again. I am now trying to compare 2 columns to find the difference between them. I have highlighted the two columns and go to format and conditional format but not sure what formula to put in. Can you help please or shall I post another question
openoffice 4.1.5 on windows 10
Re: [Solved] Export xml file to spreadsheet
Indeed.robleyd wrote:I guess the actual issue here will remain a mystery forever
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice