Hi Mariya,
what kind of xml is it? There exists already some filters and perhaps
one of them will open your file. Or you will find an existing filter in
an extension.
Are you forced to use xml or do you can get another format, e.g. csv, as
well?
Mariya Belyaeva schrieb:
Hello,
last seven days I've been trying to import my xml file into the open office
calc programme. It's my first experience with open office products and I don't
have any programming skills. I know I have to write a XSLT filter to import the
xml file as noticed in the following link
http://www.oooforum.org/forum/viewtopic.phtml?t=51387highlight=xml
But the thing is I cannot find a good step-by-step-documentation which would
help to write create the filter and embed it into the calc file and then to
open my xml document in calc. The particular questions are:
If you really need an own filter, then you would not embed it into the
Calc file, but add it to your OpenOffice via Tools XML Filter Settings
New
-what do I have to do to begin with
You would need to learn writing XSLT. That is independent of OpenOffice.
-what editor I have to use to write my filter
You can use every editor, which can write in encoding utf-8. But of
cause you will looking for a editor which give you some comfort. Which
one is suitable, depends on your operating system.
-how can I test it
Tools XML Filter Settings has a Test button, but I have never used
it, because I do not write my own filters.
-could you provide some examples of filters
and so on.
You can look into existing filters, for example the Ms Excel 2003 XML
filter in path to
OpenOffice\share\xslt\import\spreadsheetml\spreadsheetml2ooo.xsl
Could you please provide me a precise documentation for open office 4.1.1. calc
or assist me on this issue?
OpenOffice 4.1.1 Calc implements the standard ODF 1.2. You find the
documentation in https://www.oasis-open.org/standards#opendocumentv1.2
and especially, for the grammar, the schema
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-schema.rng
There exist some small additions, but you can handle them later.
Kind regards
Regina
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org