org.apache.poi.xssf.extractor

Class XSSFExcelExtractor

java.lang.Object

org.apache.poi.POITextExtractor

org.apache.poi.POIXMLTextExtractor

org.apache.poi.xssf.extractor.XSSFExcelExtractor

All Implemented Interfaces:

ExcelExtractor

public class XSSFExcelExtractor
extends POIXMLTextExtractor
implements ExcelExtractor

Helper class to extract text from an OOXML Excel file

Field Summary

Fields inherited from class org.apache.poi.POITextExtractor

document

Constructor Summary

Constructors

Constructor and Description
XSSFExcelExtractor(OPCPackage container)
XSSFExcelExtractor(java.lang.String path)
XSSFExcelExtractor(XSSFWorkbook workbook)

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.String	getText() Retreives the text contents of the file
static void	main(java.lang.String[] args)
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 true
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

Methods inherited from class org.apache.poi.POIXMLTextExtractor

getCoreProperties, getCustomProperties, getDocument, getExtendedProperties, getMetadataTextExtractor

Methods inherited from class java.lang.Object

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

Constructor Detail

XSSFExcelExtractor

public XSSFExcelExtractor(java.lang.String path)
                   throws XmlException,
                          OpenXML4JException,
                          java.io.IOException

Throws:

XmlException

OpenXML4JException

java.io.IOException

XSSFExcelExtractor

public XSSFExcelExtractor(OPCPackage container)
                   throws XmlException,
                          OpenXML4JException,
                          java.io.IOException

Throws:

XmlException

OpenXML4JException

java.io.IOException

XSSFExcelExtractor

public XSSFExcelExtractor(XSSFWorkbook workbook)

Method Detail

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

setIncludeCellComments

public void setIncludeCellComments(boolean includeCellComments)

Should cell comments be included? Default is true

Specified by:

setIncludeCellComments in interface ExcelExtractor

setIncludeHeadersFooters

public void setIncludeHeadersFooters(boolean includeHeadersFooters)

Should headers and footers be included? Default is true

getText

public java.lang.String getText()

Retreives the text contents of the file

Specified by:

getText in interface ExcelExtractor

Specified by:

getText in class POITextExtractor

Returns:

All the text from the document