org.apache.poi.xssf.extractor

Class XSSFEventBasedExcelExtractor

java.lang.Object

org.apache.poi.xssf.extractor.XSSFEventBasedExcelExtractor

All Implemented Interfaces:

java.io.Closeable, java.lang.AutoCloseable, POITextExtractor, POIXMLTextExtractor, ExcelExtractor

Direct Known Subclasses:

XSSFBEventBasedExcelExtractor

public class XSSFEventBasedExcelExtractor
extends java.lang.Object
implements POIXMLTextExtractor, ExcelExtractor

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

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected class	XSSFEventBasedExcelExtractor.SheetTextExtractor

Field Summary

Fields

Modifier and Type	Field and Description
protected boolean	concatenatePhoneticRuns
protected OPCPackage	container
protected boolean	formulasNotResults
protected boolean	includeCellComments
protected boolean	includeHeadersFooters
protected boolean	includeSheetNames
protected boolean	includeTextBoxes
protected java.util.Locale	locale
protected POIXMLProperties	properties

Constructor Summary

Constructors

Constructor and Description
XSSFEventBasedExcelExtractor(OPCPackage container)
XSSFEventBasedExcelExtractor(java.lang.String path)

Method Summary

Modifier and Type	Method and Description
protected SharedStrings	createSharedStringsTable(XSSFReader xssfReader, OPCPackage container)
POIXMLProperties.CoreProperties	getCoreProperties() Returns the core document properties
POIXMLProperties.CustomProperties	getCustomProperties() Returns the custom document properties
POIXMLDocument	getDocument() Returns opened document
POIXMLProperties.ExtendedProperties	getExtendedProperties() Returns the extended document properties
OPCPackage	getFilesystem()
boolean	getFormulasNotResults()
boolean	getIncludeCellComments()
boolean	getIncludeHeadersFooters()
boolean	getIncludeSheetNames()
boolean	getIncludeTextBoxes()
java.util.Locale	getLocale()
OPCPackage	getPackage() Returns the opened OPCPackage container.
java.lang.String	getText() Processes the file and returns the text
boolean	isCloseFilesystem()
void	processSheet(XSSFSheetXMLHandler.SheetContentsHandler sheetContentsExtractor, Styles styles, Comments comments, SharedStrings strings, java.io.InputStream sheetInputStream) Processes the given sheet
void	setCloseFilesystem(boolean doCloseFilesystem)
void	setConcatenatePhoneticRuns(boolean concatenatePhoneticRuns) Concatenate text from <rPh> text elements in SharedStringsTable Default is true;
void	setFormulasNotResults(boolean formulasNotResults) Should we return the formula itself, and not the result it produces? Default is false
void	setIncludeCellComments(boolean includeCellComments) Should cell comments be included? Default is false
void	setIncludeHeadersFooters(boolean includeHeadersFooters) Should headers and footers be included? Default is true
void	setIncludeSheetNames(boolean includeSheetNames) Should sheet names be included? Default is true
void	setIncludeTextBoxes(boolean includeTextBoxes) Should text from textboxes be included? Default is true
void	setLocale(java.util.Locale locale)

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.apache.poi.ooxml.extractor.POIXMLTextExtractor

checkMaxTextSize, close, getMetadataTextExtractor

Field Detail

container

protected final OPCPackage container

properties

protected final POIXMLProperties properties

locale

protected java.util.Locale locale

includeTextBoxes

protected boolean includeTextBoxes

includeSheetNames

protected boolean includeSheetNames

includeCellComments

protected boolean includeCellComments

includeHeadersFooters

protected boolean includeHeadersFooters

formulasNotResults

protected boolean formulasNotResults

concatenatePhoneticRuns

protected boolean concatenatePhoneticRuns

Constructor Detail

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

Method Detail

setIncludeSheetNames

public void setIncludeSheetNames(boolean includeSheetNames)

Should sheet names be included? Default is true

Specified by:

setIncludeSheetNames in interface ExcelExtractor

Parameters:

includeSheetNames - true if the sheet names should be included

getIncludeSheetNames

public boolean getIncludeSheetNames()

Returns:

whether to include sheet names

Since:

3.16-beta3

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

Parameters:

formulasNotResults - true if the formula itself is returned

getFormulasNotResults

public boolean getFormulasNotResults()

Returns:

whether to include formulas but not results

Since:

3.16-beta3

setIncludeHeadersFooters

public void setIncludeHeadersFooters(boolean includeHeadersFooters)

Should headers and footers be included? Default is true

Specified by:

setIncludeHeadersFooters in interface ExcelExtractor

Parameters:

includeHeadersFooters - true if headers and footers should be included

getIncludeHeadersFooters

public boolean getIncludeHeadersFooters()

Returns:

whether or not to include headers and footers

Since:

3.16-beta3

setIncludeTextBoxes

public void setIncludeTextBoxes(boolean includeTextBoxes)

Should text from textboxes be included? Default is true

getIncludeTextBoxes

public boolean getIncludeTextBoxes()

Returns:

whether or not to extract textboxes

Since:

3.16-beta3

setIncludeCellComments

public void setIncludeCellComments(boolean includeCellComments)

Should cell comments be included? Default is false

Specified by:

setIncludeCellComments in interface ExcelExtractor

Parameters:

includeCellComments - true if cell comments should be included

getIncludeCellComments

public boolean getIncludeCellComments()

Returns:

whether cell comments should be included

Since:

3.16-beta3

setConcatenatePhoneticRuns

public void setConcatenatePhoneticRuns(boolean concatenatePhoneticRuns)

Concatenate text from <rPh> text elements in SharedStringsTable Default is true;

Parameters:

concatenatePhoneticRuns - true if runs should be concatenated, false otherwise

setLocale

public void setLocale(java.util.Locale locale)

getLocale

public java.util.Locale getLocale()

Returns:

locale

Since:

3.16-beta3

getPackage

public OPCPackage getPackage()

Returns the opened OPCPackage container.

Specified by:

getPackage in interface POIXMLTextExtractor

Returns:

the opened OPCPackage

getCoreProperties

public POIXMLProperties.CoreProperties getCoreProperties()

Returns the core document properties

Specified by:

getCoreProperties in interface POIXMLTextExtractor

Returns:

the core document properties

getExtendedProperties

public POIXMLProperties.ExtendedProperties getExtendedProperties()

Returns the extended document properties

Specified by:

getExtendedProperties in interface POIXMLTextExtractor

Returns:

the extended document properties

getCustomProperties

public POIXMLProperties.CustomProperties getCustomProperties()

Returns the custom document properties

Specified by:

getCustomProperties in interface POIXMLTextExtractor

Returns:

the custom document properties

processSheet

public void processSheet(XSSFSheetXMLHandler.SheetContentsHandler sheetContentsExtractor,
                         Styles styles,
                         Comments comments,
                         SharedStrings 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

createSharedStringsTable

protected SharedStrings createSharedStringsTable(XSSFReader xssfReader,
                                                 OPCPackage container)
                                          throws java.io.IOException,
                                                 org.xml.sax.SAXException

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 POITextExtractor

Specified by:

getText in interface ExcelExtractor

Returns:

All the text from the document

getDocument

public POIXMLDocument getDocument()

Description copied from interface: POIXMLTextExtractor

Returns opened document

Specified by:

getDocument in interface POITextExtractor

Specified by:

getDocument in interface POIXMLTextExtractor

Returns:

the opened document

setCloseFilesystem

public void setCloseFilesystem(boolean doCloseFilesystem)

Specified by:

setCloseFilesystem in interface POITextExtractor

Parameters:

doCloseFilesystem - true (default), if underlying resources/filesystem should be closed on POITextExtractor.close()

isCloseFilesystem

public boolean isCloseFilesystem()

Specified by:

isCloseFilesystem in interface POITextExtractor

Returns:

true, if resources/filesystem should be closed on POITextExtractor.close()

getFilesystem

public OPCPackage getFilesystem()

Specified by:

getFilesystem in interface POITextExtractor

Returns:

The underlying resources/filesystem