[MS-EXCEL] excel XLUnicodeRichExtendedString length not equal the sum of the lengths of ites items?

LEO 0 Reputation points
2023-08-02T08:15:53.1233333+00:00

I want to get all the Strings in an excel , I know it stores in the SST , when I analyze the SST use offvis , I find something I cannot understand , some XLUnicodeRichExtendedString size not equal the sum of the length of the items in it , How can I obtain the correct length?

ie, XLUnicodeRichExtendedString[272] size is 34 , WHY? the sum of the length of cch/flags/rgbString is 30 ?

xls

Microsoft 365 and Office Excel For business Windows
{count} votes

1 answer

Sort by: Most helpful
  1. LEO 0 Reputation points
    2023-08-03T10:07:40.84+00:00

    I know the answer by reading the sourcecode of libxls , I cannot parse XLUnicodeRichExtendedString as a list , the XLUnicodeRichExtendedString data is in SST(type = 252) or Continue (type = 60) sector , one XLUnicodeRichExtendedString may cross over a sector

    thanks

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.