for Excel to properly handle non-ASCII characters cou need to specify HSSFCell cell; cell.setEncoding(HSSFCell.ENCODING_UTF16);
or something like that - I am quoting from the top of my head here - for each cell that contains a "special" character. Search this list - it has been discussed before. Unix will propably use a default encoding of UTF-8 (check the LC_* environment variables) whereas Windows will use your local encoding (Propably LATIN-2 for you) Check the Site http://www.joelonsoftware.com/articles/Unicode.html for an excellent explanation of how and why the different encodings evolved and what you should know these days to handle them. Hth, Tobias > -----Original Message----- > From: Tahir Akhtar [mailto:[EMAIL PROTECTED] > Sent: Friday, May 05, 2006 12:56 PM > To: 'POI Users List' > Subject: RE: Major Problem With POI Excel reader: Urgent Help Needed > > > Birendar, > > I think you would have to share some more information, perhaps a code > snippet if you expect any help from the forum. Try to explain > your problem > in more detail. > > Latest "release" of poi can be downloaded from poi website > which is 2.5.1. > You can also get the latest development version from the dev > directory. Both > release and development versions are available in source and > binary forms. > > Your problems seems to be related to handling of encoding. > But I do not have > anything to say about it :). > > > Regards, > Tahir Akhtar > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, May 05, 2006 3:10 PM > To: POI Users List > Subject: Major Problem With POI Excel reader: Urgent Help Needed > > Hi , > I am using POI API for reading data from an excel file , > which is advance > version of the API that read data from text file, to increase > the character > bandwidth ie to support special charater . However the POI api are not > reading special character properly. On unix they behave > differently and on > windows they behave dirrerently. > However my text file parser is supporting more special > character them my > excel reader. > I am facing problem with the character "Š, š, Ž, ž" whcih are > read well and > inserted into databse well. But in poi apis it fail to read > them properly. > On windows they are read different them unix. > > If any one has ever face such problem please help me, I have > posting my > probwelm to this forum frequently for last few days but this > seems to be > dead forum. > Can anyone tell me from where exactly I can get the POI jar > latest and > what is the lates version of it ? > The site is so old . > > Please help > Thanks > Regards > Birenadr S Waldiya > =====-----=====-----===== > Notice: The information contained in this e-mail > message and/or attachments to it may contain > confidential or privileged information. If you are > not the intended recipient, any dissemination, use, > review, distribution, printing or copying of the > information contained in this e-mail message > and/or attachments to it are strictly prohibited. If > you have received this communication in error, > please notify us by reply e-mail or telephone and > immediately and permanently delete the message > and any attachments. Thank you > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.392 / Virus Database: 268.5.4/332 - Release > Date: 5/4/2006 > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.392 / Virus Database: 268.5.4/332 - Release > Date: 5/4/2006 > > > > --------------------------------------------------------------------- > 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/ > --------------------------------------------------------------------- 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/
