File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes XML and Related Technologies and the fly likes XML parse error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "XML parse error" Watch "XML parse error" New topic

XML parse error

venkat warlu

Joined: Mar 05, 2008
Posts: 7
Hi all.

I have written a java program which connects db2 database and gets some columns and writes into a .xml file. Now i when i open the file in xml format there data is fine is no error.
But when i open the file in excel format , it shows some error called "XML parse error. unable to open . Data failed ".

In my opinion the error is due to some unreadable special characters present in the columns in database.
How do i get the data in excel sheet without any errors. How do i rectify the problem by avoiding the unnecessary characters.

Please help me.
Thnaks in advance.
Paul Clapham

Joined: Oct 14, 2005
Posts: 19848

You will want to write the XML document correctly. In particular (1) you should use an encoding which can encode all of the characters in your document -- UTF-8 works nicely, or UTF-16 if your document is mostly non-European scripts -- and (2) when you write the document you should actually use that encoding.

Here's a link to a tutorial about XML and encodings.
I agree. Here's the link:
subject: XML parse error
It's not a secret anymore!