special character in xml document (from excel)

[quickcur]

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.createElement(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

 

[Peter Flynn]

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.createElement(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