Create your xslt filter...
Edit: http://www.youtube.com/watch?v=tNfGyIW7aHM |
Is there any way to do this?
[...]
It has flat structure, easy to map to cells.
I know such functionality is available in Microsoft Office is it available in OpenOffice.
alfas wrote:I have a simple XML file and I want to open it with Calc.
alfas wrote:<r><a>275726</a><m>45</m><p>Jul 22, 2008 12:00:00 AM</p></r>
<table:table-column table:style-name="co1" table:default-cell-style-name="xDT"/>
<table:table-cell office:value-type="date" office:date-value="1999-12-31T23:59:59">
<text:p>31/12/99 23:59</text:p>
</table:table-cell>
<table:table-cell office:value-type="date" office:date-value="1999-12-31T23:59:59">
</table:table-cell>
<table:table-cell>
<text:p>31/12/99 23:59</text:p>
</table:table-cell>
I still wish that there would be some plug-in to have this conversion automatically. It is too complex for most of users to use XSL-T template, not to mention writing one.
Villeroy wrote:I have never imported XML in Excel and I have no clue if my German version of Excel could import your XML that easily.
ClarDold wrote:... I have yet to figure out how to make a .xslt for them, ...
Villeroy wrote:BaseX is true magic.
ClarDold wrote:Maybe I'm missing the simple invocation.
I want basex to take in the Preview.xml, and write a "good" .xml with style, or maybe, separately, write the style map so I can use it.
karolus wrote:Hallo
Libreoffice comes with a generic xml-importer ( →Data→→XML-Source....)
Maybe give it a try.
Villeroy wrote:XML is a file format for developers only.
ClarDold wrote:Villeroy wrote:XML is a file format for developers only.
And MS Excel does a good job at providing me with a useful modeling tool for that raw xml, without programming.
Villeroy wrote:Great. Then use MS Excel.
ClarDold wrote:Villeroy wrote:Great. Then use MS Excel.
Such a sad thought.
Villeroy wrote: Every single time you open some XML file, you need to drag and drop the right elements from a tree control to the right places in your sheet.
Users browsing this forum: No registered users and 41 guests