SharedStringItem class

Office 2013 and later

String Item. When the object is serialized out as xml, its qualified name is x:si.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

[ISO/IEC 29500-1 1st Edition]

si (String Item)

This element is the representation of an individual string in the Shared String table.

If the string is just a simple string with formatting applied at the cell level, then the String Item (si) should contain a single text element used to express the string. However, if the string in the cell is more complex - i.e., has formatting applied at the character level - then the string item shall consist of multiple rich text runs which collectively are used to express the string.

Parent Elements

sst (§18.4.9)

Child Elements

Subclause

phoneticPr (Phonetic Properties)

§18.4.3

r (Rich Text Run)

§18.4.4

rPh (Phonetic Run)

§18.4.6

t (Text)

§18.4.12

[Note: The W3C XML Schema definition of this element’s content model (CT_Rst) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show: