This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
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

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
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: 19973

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!