Package org.apache.poi.xssf.eventusermodel

Class ReadOnlySharedStringsTable

  • All Implemented Interfaces:
    SharedStrings, ContentHandler, DTDHandler, EntityResolver, ErrorHandler
    public class ReadOnlySharedStringsTable
extends DefaultHandler
implements SharedStrings

    This is a lightweight way to process the Shared Strings table. Most of the text cells will reference something from in here.

    Note that each SI entry can have multiple T elements, if the string is made up of bits with different formatting.

    Example input: 

    <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="2" uniqueCount="2">
 <si>
   <r>
     <rPr>
       <b />
       <sz val="11" />
       <color theme="1" />
       <rFont val="Calibri" />
       <family val="2" />
       <scheme val="minor" />
     </rPr>
     <t>This:</t>
   </r>
   <r>
     <rPr>
       <sz val="11" />
       <color theme="1" />
       <rFont val="Calibri" />
       <family val="2" />
       <scheme val="minor" />
     </rPr>
     <t xml:space="preserve">Causes Problems</t>
   </r>
 </si>
 <si>
   <t>This does not</t>
 </si>
</sst>