webapp - exporting to excel problem with csv

[anish joseph]

I am trying to export some data that has chinese characters to an excel file.
What i have done so far is this:

        String chineseString = getChineseStringFromSomewhere();
response.setContentType("charset=UTF-8");
        response.setContentType("application/vnd.ms-excel");
        OutputStream out = response.getOutputStream();
        out.write(chineseString.getBytes("UTF-8");
        out.close();

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.

thanks
-monk