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.
Created attachment 23255 [details] csv file
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
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;