Can you please tell me , programaticaaly how to crate excel sheet and exporting it to CSV?
You're missing the point. What I'm suggesting is that you create an XLS file
manually -in Excel- that contains Unicode characters, and export that to CSV. If you can import that correctly back into Excel know at least know what Excel can deal with, so you know what the web app needs to generate.
Also what is tranfering encoding? what transfering encoding should I use in this case?
Well, in your example you are retrieving the CSV you're writing to the file from an HTTP request. So if you don't get proper results,
you should investigate if that HTTP request is properly encoded (it should be encoded in "UTF-8").
[ May 02, 2007: Message edited by: Ulf Dittmer ]