|Summary:||Turkish character support|
|Component:||XSSF||Assignee:||POI Developers List <dev>|
Description Tufan 2009-02-13 05:33:46 UTC
When I try to write Turkish ( 'ş', 'ğ', 'İ', 'Ş', 'Ğ' ) characters into a new Excel file, I am having display errors. However,when it comes to write other characters like ('i', 'ü', 'ç') it displays properly in the generated Excel file. I attached the sample generated Excel file. It would be useful to add Turkish character support to POI. I apply the lines below when inserting new values into all of the cells in the Excel sheet : HSSFCell cell0 = row.getCell((short) 0); cell0.setCellStyle(cellStyle); cell0.setCellType(HSSFCell.CELL_TYPE_STRING); cell0.setEncoding(HSSFCell.ENCODING_UTF_16); I am using poi 2.5.1 version. Thanks in advance.
Comment 2 Nick Burch 2009-02-13 05:39:53 UTC
poi 2.5.1 is over 4 years old... Try with a recent POI version. If you have your java correctly setup for unicode (most people do), you'll then be fine to put unicode in richtextstrings and have them displayed
Comment 3 Tufan 2009-02-13 06:15:32 UTC
Hi; I have just updated the version of POI used to 3.1 and it started to work correctly. Thanks for your help and consideration. Regards;