org.apache.poi.xssf.extractor
Class XSSFEventBasedExcelExtractor

java.lang.Object
  org.apache.poi.POITextExtractor
      org.apache.poi.POIXMLTextExtractor
          org.apache.poi.xssf.extractor.XSSFEventBasedExcelExtractor

All Implemented Interfaces:

java.io.Closeable, ExcelExtractor

public class XSSFEventBasedExcelExtractor
extends POIXMLTextExtractor
implements ExcelExtractor

Implementation of a text extractor from OOXML Excel files that uses SAX event based parsing.

XSSFEventBasedExcelExtractor

public XSSFEventBasedExcelExtractor(java.lang.String path)
                             throws org.apache.xmlbeans.XmlException,
                                    OpenXML4JException,
                                    java.io.IOException

Throws:

org.apache.xmlbeans.XmlException

OpenXML4JException

java.io.IOException

XSSFEventBasedExcelExtractor

public XSSFEventBasedExcelExtractor(OPCPackage container)
                             throws org.apache.xmlbeans.XmlException,
                                    OpenXML4JException,
                                    java.io.IOException

Throws:

org.apache.xmlbeans.XmlException

OpenXML4JException

java.io.IOException

main

public static void main(java.lang.String[] args)
                 throws java.lang.Exception

Throws:

java.lang.Exception

setIncludeSheetNames

public void setIncludeSheetNames(boolean includeSheetNames)

Should sheet names be included? Default is true

Specified by:

setIncludeSheetNames in interface ExcelExtractor

setFormulasNotResults

public void setFormulasNotResults(boolean formulasNotResults)

Should we return the formula itself, and not the result it produces? Default is false

Specified by:

setFormulasNotResults in interface ExcelExtractor

setIncludeHeadersFooters

public void setIncludeHeadersFooters(boolean includeHeadersFooters)

Should headers and footers be included? Default is true

Specified by:

setIncludeHeadersFooters in interface ExcelExtractor

setIncludeTextBoxes

public void setIncludeTextBoxes(boolean includeTextBoxes)

Should text from textboxes be included? Default is true

setIncludeCellComments

public void setIncludeCellComments(boolean includeCellComments)

Should cell comments be included? Default is false

Specified by:

setIncludeCellComments in interface ExcelExtractor

setLocale

public void setLocale(java.util.Locale locale)

getPackage

public OPCPackage getPackage()

Returns the opened OPCPackage container.

Overrides:

getPackage in class POIXMLTextExtractor

getCoreProperties

public POIXMLProperties.CoreProperties getCoreProperties()

Returns the core document properties

Overrides:

getCoreProperties in class POIXMLTextExtractor

getExtendedProperties

public POIXMLProperties.ExtendedProperties getExtendedProperties()

Returns the extended document properties

Overrides:

getExtendedProperties in class POIXMLTextExtractor

getCustomProperties

public POIXMLProperties.CustomProperties getCustomProperties()

Returns the custom document properties

Overrides:

getCustomProperties in class POIXMLTextExtractor

processSheet

public void processSheet(XSSFSheetXMLHandler.SheetContentsHandler sheetContentsExtractor,
                         StylesTable styles,
                         CommentsTable comments,
                         ReadOnlySharedStringsTable strings,
                         java.io.InputStream sheetInputStream)
                  throws java.io.IOException,
                         org.xml.sax.SAXException

Processes the given sheet

Throws:

java.io.IOException

org.xml.sax.SAXException

getText

public java.lang.String getText()

Processes the file and returns the text

Specified by:

getText in interface ExcelExtractor

Specified by:

getText in class POITextExtractor

Returns:

All the text from the document

close

public void close()
           throws java.io.IOException

Description copied from class: POITextExtractor

Allows to free resources of the Extractor as soon as it is not needed any more. This may include closing open file handles and freeing memory. The Extractor cannot be used after close has been called.

Specified by:

close in interface java.io.Closeable

Overrides:

close in class POIXMLTextExtractor

Throws:

java.io.IOException