Markus Jacob wrote:
Thanks Paul, I've looked at the page you've mentioned, and having no
programming experience this doesn't seem to be an option.
When 'Save as' the Calc spreadsheet, there does not seem to be an option
to save as the native OOo XML format. There are many other formats
available (incl. saveing as an Excel 2003 XML file), but no other XML
file. Could you or someone else pleaseshed some light on that?
Many thanks!
Markus
On 25 Jul 2007, at 21:24, Paul wrote:
I'm on a Mac (OS X) and want to save a Calc file as a XML tagged
document. Column headers should be used as XML tags. Pretty exactly
what is described herre: http://sobolsoft.com/excelexportxml/ Is
there any chance to do that automatically?
Many thanks!
I can see two possible options. You can write your own XML export
filter for OOo . Some useful advice can be found here :
http://xml.openoffice.org/filter/ .
Alternatively you could massage the XML that is created when a calc
file is saved in the native OOo XML...
/paul
--
Processing Key for cracking HD DVD's:
09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0
-----
Try Torpark; a small portable, open-source, built on Firefox browser
that enables anonymous browsing. Requires no installation :
http://www.torrify.com/
Hello Paul,
The default file format for OpenOffice is in an XML format. It is
compressed so all you need to do is unzip the *.ods (spreadsheet file)
and in the resulting files you will have a full selection of files.
I created a file temp.ods.
When I unzipped it, I ended up with.
extracting: mimetype
creating: Configurations2/statusbar/
inflating: Configurations2/accelerator/current.xml
creating: Configurations2/floater/
creating: Configurations2/popupmenu/
creating: Configurations2/progressbar/
creating: Configurations2/menubar/
creating: Configurations2/toolbar/
creating: Configurations2/images/Bitmaps/
inflating: content.xml
inflating: styles.xml
inflating: meta.xml
inflating: Thumbnails/thumbnail.png
inflating: settings.xml
inflating: META-INF/manifest.xml
I looked at your example and it looks like you want a csv type of file
that is formated as a very basic XML file. A macro could be written to
convert a csv file or within OOo itself. The default OOo XML format has
much more detail within it. I tried the other XML formats and they are
all much more complicated for what you want.
Someone may have used a macro like it.
For your information, the Microsoft OOXML is similar to the OpenOffice
XML file format.
I wonder how this add-on deals with formulas or calculated cells.
--
Due to the move to Exchange Server,
anything that is a priority, please phone.
Robin Laing
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
