[Solved] Export xml file to spreadsheet

Discuss the spreadsheet application
Post Reply
lbyham
Posts: 6
Joined: Tue Jan 16, 2018 8:24 pm

[Solved] Export xml file to spreadsheet

Post by lbyham »

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]
openoffice 4.1.5 on windows 10
User avatar
robleyd
Moderator
Posts: 5055
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: export xml file to spreadsheet

Post by robleyd »

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.
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
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Export xml file to spreadsheet

Post by Villeroy »

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.
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
lbyham
Posts: 6
Joined: Tue Jan 16, 2018 8:24 pm

Re: Export xml file to spreadsheet

Post by lbyham »

Thanks for your help. I have found a Playlist Converter app that has done it
Thanks again
openoffice 4.1.5 on windows 10
User avatar
robleyd
Moderator
Posts: 5055
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Solved] Export xml file to spreadsheet

Post by robleyd »

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
lbyham
Posts: 6
Joined: Tue Jan 16, 2018 8:24 pm

Re: [Solved] Export xml file to spreadsheet

Post by lbyham »

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
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Export xml file to spreadsheet

Post by Villeroy »

robleyd wrote:I guess the actual issue here will remain a mystery forever :?:
Indeed.
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
Post Reply