«

I am rewrite some of my excel sheets to xml document. In my excel,
there is a lot of special characters like "/", " " (space), "#", "+'.
I am using a java program based on JDom to to create xml. The program
is complaining about those characters with the exception like

org.w3c.dom.DOMException: INVALID_CHARACTER_ERR: An invalid or illegal
XML character is specified.
at org.apache.xerces.dom.CoreDocumentImpl.createEleme nt(Unknown
Source)
at Excel2Xml.main(Excel2Xml.java:41)

What is the best way to handle this? I do want to keep those special
characters in my document.

Thanks,

qq

wrote:

> I am rewrite some of my excel sheets to xml document. In my excel,
> there is a lot of special characters like "/", " " (space), "#", "+'.

None of those is special in XML. Only < and & have a special meaning to
start with.

> I am using a java program based on JDom to to create xml. The program
> is complaining about those characters with the exception like
>
> org.w3c.dom.DOMException: INVALID_CHARACTER_ERR: An invalid or illegal
> XML character is specified.
> at org.apache.xerces.dom.CoreDocumentImpl.createEleme nt(Unknown
> Source)
> at Excel2Xml.main(Excel2Xml.java:41)
>
> What is the best way to handle this? I do want to keep those special
> characters in my document.

Without seeing exactly what character it is complaining about, it's
not possible to answer this question.

///Peter
--
"The cat in the box is both a wave and a particle"
-- Terry Pratchett, introducing quantum physics in _The Authentic Cat_