Hi, that would be of particular interest for me, too.
We have some international names in our application, although it runs in a ISO-Latin-1 (ISO-8859-1) [db, appserver] / Cp1252 [client] environment with deDE locale by default. We have several areas of "visibility" like DB (VarChar fields), Java source files, appserver console, JSP source / rendering / display, PDF and XLS download. Actually we use the last POI final (should be 2.5.1?), and I do not remember any possibility of setting the encoding for String values in a sheet. Since the XLS file format is kind of a "hybrid" one, mixed up from binary structure / control data and textual content data, it is crucial to fill in all textual "content" with the appropriate encoding -- and that one should be subject to set up / choose. Testing some examples I found that - very most characters found in our data are displayed as they should, in JSP and XLS (by POI). - the czech "s with v on top" is displayed well in JSPs, but not in POI generated XLS: There it shows up as "little rectangle". I know that in ISO-8859-1 there are also problems with danish "o with slash" also, but currently I have no test data. Also I would expect problems with turkish letters like "i without dot" or "c with bottom accent", like in the city name "Incirlik", when written correctly. btw: In JXL (JExcelAPI) it is posible to set up an encoding for a generated XLS file, which by default is "the default encoding of the hosting VM", but it took a while to make that happen. Regards Christian Gosch inovex GmbH On Tuesday, November 08, 2005 11:59 PM [GMT+1=CET], Olivier Matt <[EMAIL PROTECTED]> wrote: > Hello, > > I'm reading excel files and I get from a CELL_TYPE_STRING cell a > String. > > That string has some problems with accents (I guess the file is > encoded using > some latin-characters encoding), they are not seen properly. > > How can I avoid this behavior ? Can I specify somewhere the encoding > of the cells ? > Or is there a method for transforming misinterpreted strings to good > latin-strings ? > > > Thanks for help, > > Olivier > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ -- Dipl.-Inform. Christian Gosch Systems Development inovex GmbH mailto:[EMAIL PROTECTED] http://www.inovex.de --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
