Export to XML flat data table?

Discuss the spreadsheet application
Post Reply
inaction_figure
Posts: 2
Joined: Wed Oct 10, 2012 11:44 pm

Export to XML flat data table?

Post by inaction_figure »

Hi,

In order to generate simple flat XML data tables, I'd like to be able to export a table from Calc to XML. I'm thinking of the "Developer" Export to XML functionality in M$ Excel.

I'm using Linux Mint 12 and LibreOffice 3.4.4.

If I'm going about this the wrong way, please point me in the right direction.

Thanks in advance,
Eric
LibreOffice 3.4.4 on Linux Mint 12
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Export to XML flat data table?

Post by Villeroy »

$ unzip foo.ods content.xml
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
inaction_figure
Posts: 2
Joined: Wed Oct 10, 2012 11:44 pm

Re: Export to XML flat data table?

Post by inaction_figure »

Well, yes, that IS an XML file. So, thank you, but I should have been more specific.

Is there a way, besides creating XSLT transformations to use with the "XML Filter Settings", to export from a table in Calc to an XML with a schema with named records and fields?

For that matter, is there an easy way to create the XSLT stylesheet?

Thanks,
Eric
LibreOffice 3.4.4 on Linux Mint 12
User avatar
Robert Tucker
Volunteer
Posts: 1250
Joined: Mon Oct 08, 2007 1:34 am
Location: Manchester UK

Re: Export to XML flat data table?

Post by Robert Tucker »

Have you read this thread from the other forum:

http://www.oooforum.org/forum/viewtopic.phtml?t=6809

You could also have a look at iReport:

http://community.jaspersoft.com/project ... t-designer

though writing an xslt might be easier than getting through their tutorials!
LibreOffice 7.x.x on Arch and Fedora.
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Export to XML flat data table?

Post by Villeroy »

Robert Tucker wrote:Have you read this thread from the other forum:

http://www.oooforum.org/forum/viewtopic.phtml?t=6809
That topic on oooforum.org is a perfect example of what goes wrong when people refer to meta file formats as if they were file formats. Just like CSV, XML is not a file format. XML is a standard about how to write your own file formats (csv is not even a standard).
Someone who names himself "Dave_is_sexy" insists in some magic feature to perform the type of conversion he needs right now in the most convenient manner (how unsexy!). He does not drop a single line of input data to be transfered nor any example about the actual output format he needs. At least he could mention some other application which is supposed to import the exported XML. Sexy Dave wants to find some useful idiot to do all the coding for him. Having found one, he is not even able to analyse and debug the code that has been given to him and that is the end of that topic. It's not difficult to imagine how he behaves in sex life.
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