Class ReadOnlySharedStringsTable

java.lang.Object
org.xml.sax.helpers.DefaultHandler
org.apache.poi.xssf.eventusermodel.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>