my application need to display the greek data from jsp to the excel sheet but i am not able to display the greek charcaters in excel even after using utf-8 character encoding. i tried with iso-8859-7 also even then its taking by default windows-latin encoding.
my code goes like this: <% Vector x = (Vector)session.getAttribute("QRES");
Your setContentType seems to have a colon where it should have a semicolon. But you're not actually creating an Excel file, you're creating a CSV file, and I don't think the browser passes on to Excel what it thinks the file is encoded in. Have you tried adding an UTF-8 signature to the file?
Ping & DNS - updated with new look and Ping home screen widget
Joined: Apr 24, 2006
no doubt the browser is opening the file in excel(even the .CSV file wud get opened in excel only as far as my knowledge goes) but if the same file if i try to open with MSWord document its displaying THE GREEK CHARACTERS correctly with UTF-8 ENCODING but with the same UTF-8 encoding i am unable to display the greek characters correctly in excel sheet. is there any alternative way to display the non-ascii characters correctly in excel?
Alternative to csv is html which can use meta tag to set encoding (the meta tag may not work in Excel and it has to have .xls extension to open in Excel) or real xls format created by Jakarta POI (which allows utf-8 or utf-16).