I am trying to export some data that has chinese characters to an excel file. What i have done so far is this:
Now when the export happens the browser asks if the file needs to be opened/saved? If i open the file then i DONT see the chinese characters. However, if i save the file as somefile.txt and open this with excel (outside the browser) then Excel takes me thru a small wizard and the chines characters show up correctly.
Its clear that the characters are being correctly generated in the servlet and sent (since when i save the file and open it the correct strings are in there). Any help would be appreciated.
I will suppress my every urge. But not this shameless plug: