This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

XML parse error

 
venkat warlu
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 21961
36
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!