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.