Hi everybody,
I have create a sheet name 'cao' and read it with
field_5_sheetname = new String(data, 8 + offset,
LittleEndian.ubyteToInt( field_3_sheetname_length),"ISO-8859-1");
in protected void fillFields(byte [] data, short size, int offset) of
BoundSheetRecord for ((field_4_compressed_unicode_flag & 0x01)==0) case
and I got the correct interpetation using java JLabel to display it. Without the
charsetName, "ISO-8859-1" in this case, the sheet name was read in incorrectly.
My question is :
It seems that inside excel workbook format there is a InterfaceHdrRecord which has
only a single field named field_1_codepage. If we plug it in the compressed unicode
string conversion (like the above code), it might solve more problem for us. For
example, portuguese character for me and probably Russian, since somebody say on the
list that some of russian char code is located between 127 and 255. Does anyone on
the list has the corresponding code for field_1_codepage to charsetName? In my case,
the field_1_codepage is the default(?)
public final static short CODEPAGE = ( short ) 0x4b0;
And I plug in "ISO-8859-1" and it come out allright. Today is probably my lucky day :)
Regards
Patrick Lee
