org.apache.poi.xssf.eventusermodel

Class XSSFSheetXMLHandler

java.lang.Object

org.xml.sax.helpers.DefaultHandler

org.apache.poi.xssf.eventusermodel.XSSFSheetXMLHandler

All Implemented Interfaces:

ContentHandler, DTDHandler, EntityResolver, ErrorHandler

public class XSSFSheetXMLHandler
extends DefaultHandler

This class handles the streaming processing of a sheet#.xml sheet part of a XSSF .xlsx file, and generates row and cell events for it. This allows to build functionality which reads huge files without needing large amounts of main memory. See XSSFSheetXMLHandler.SheetContentsHandler for the interface that you need to implement for reading information from a file.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static interface	XSSFSheetXMLHandler.SheetContentsHandler This interface allows to provide callbacks when reading a sheet in streaming mode.

Constructor Summary

Constructors

Constructor and Description
XSSFSheetXMLHandler(Styles styles, Comments comments, SharedStrings strings, XSSFSheetXMLHandler.SheetContentsHandler sheetContentsHandler, DataFormatter dataFormatter, boolean formulasNotResults) Accepts objects needed while parsing.
XSSFSheetXMLHandler(Styles styles, SharedStrings strings, XSSFSheetXMLHandler.SheetContentsHandler sheetContentsHandler, boolean formulasNotResults) Accepts objects needed while parsing.
XSSFSheetXMLHandler(Styles styles, SharedStrings strings, XSSFSheetXMLHandler.SheetContentsHandler sheetContentsHandler, DataFormatter dataFormatter, boolean formulasNotResults) Accepts objects needed while parsing.

Method Summary

Modifier and Type	Method and Description
void	characters(char[] ch, int start, int length) Captures characters only if a suitable element is open.
void	endElement(String uri, String localName, String qName)
void	startElement(String uri, String localName, String qName, Attributes attributes)

Methods inherited from class org.xml.sax.helpers.DefaultHandler

endDocument, endPrefixMapping, error, fatalError, ignorableWhitespace, notationDecl, processingInstruction, resolveEntity, setDocumentLocator, skippedEntity, startDocument, startPrefixMapping, unparsedEntityDecl, warning

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

XSSFSheetXMLHandler

public XSSFSheetXMLHandler(Styles styles,
                           Comments comments,
                           SharedStrings strings,
                           XSSFSheetXMLHandler.SheetContentsHandler sheetContentsHandler,
                           DataFormatter dataFormatter,
                           boolean formulasNotResults)

Accepts objects needed while parsing.

Parameters:

styles - Table of styles

strings - Table of shared strings

XSSFSheetXMLHandler

public XSSFSheetXMLHandler(Styles styles,
                           SharedStrings strings,
                           XSSFSheetXMLHandler.SheetContentsHandler sheetContentsHandler,
                           DataFormatter dataFormatter,
                           boolean formulasNotResults)

Accepts objects needed while parsing.

Parameters:

styles - Table of styles

strings - Table of shared strings

XSSFSheetXMLHandler

public XSSFSheetXMLHandler(Styles styles,
                           SharedStrings strings,
                           XSSFSheetXMLHandler.SheetContentsHandler sheetContentsHandler,
                           boolean formulasNotResults)

Accepts objects needed while parsing.

Parameters:

styles - Table of styles

strings - Table of shared strings

Method Detail

startElement

public void startElement(String uri,
                         String localName,
                         String qName,
                         Attributes attributes)
                  throws SAXException

Specified by:

startElement in interface ContentHandler

Overrides:

startElement in class DefaultHandler

Throws:

SAXException

endElement

public void endElement(String uri,
                       String localName,
                       String qName)
                throws SAXException

Specified by:

endElement in interface ContentHandler

Overrides:

endElement in class DefaultHandler

Throws:

SAXException

characters

public void characters(char[] ch,
                       int start,
                       int length)
                throws SAXException

Captures characters only if a suitable element is open. Originally was just "v"; extended for inlineStr also.

Specified by:

characters in interface ContentHandler

Overrides:

characters in class DefaultHandler

Throws:

SAXException