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