chinese problem

Mar 23, 2009 at 1:56 AM
if excel have chinese word,the word will be lose.

maybe is encoding problem.

but, the object have too much encoding setting in anywhere.

any one know how to fix it?


Jun 24, 2013 at 4:31 PM
I am having the same issue. A cell with Chinese characters in it, comes out as an empty string. Oddly enough the first cell with Chinese worked, but then every other cell had an empty string for the value of the column...
Developer
Jun 26, 2013 at 10:41 AM
Hmmm not sure. Sounds like a bug but I don't have time right now to open the code up. Your best bet is to download the latest source and try and step through it.
Oct 11, 2013 at 10:56 PM
The issue is with Unicode strings that use phonetic string data.

Per: http://msdn.microsoft.com/en-us/library/dd943830(v=office.12).aspx

The 3rd byte in the XLUnicodeRichExtendedString record, 3 bit in that byte, if it's enabled, the string has Extended data...

Funny enough, ExcelDataReader support this, but it's been commented out for a very long time:
        /// <summary>
        /// Checks if string has Extended record
        /// </summary>
        public bool HasExtString
        {
            get { return false; }
            // ((Flags & FormattedUnicodeStringFlags.HasExtendedString) == FormattedUnicodeStringFlags.HasExtendedString); }
        }
Remove the comments on the flag test, and Extended unicode strings won't blow up the SST.