aspose file tools*
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
Author

XML parse error

venkat warlu
Greenhorn

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
Bartender

Joined: Oct 14, 2005
Posts: 18992
    
    8

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: http://aspose.com/file-tools
 
subject: XML parse error