org.apache.poi.xssf.extractor
Class XSSFExcelExtractor

java.lang.Object
  extended by org.apache.poi.POITextExtractor
      extended by org.apache.poi.POIXMLTextExtractor
          extended by 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
static XSSFRelation[] SUPPORTED_TYPES
           
 
Fields inherited from class org.apache.poi.POITextExtractor
document
 
Constructor Summary
XSSFExcelExtractor(OPCPackage container)
           
XSSFExcelExtractor(java.lang.String path)
          Deprecated. Use XSSFExcelExtractor(org.apache.poi.openxml4j.opc.OPCPackage) instead.
XSSFExcelExtractor(XSSFWorkbook workbook)
           
 
Method Summary
 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
 void setLocale(java.util.Locale locale)
          What Locale should be used for formatting numbers (based on the styles applied to the cells)
 
Methods inherited from class org.apache.poi.POIXMLTextExtractor
getCoreProperties, getCustomProperties, getDocument, getExtendedProperties, getMetadataTextExtractor, getPackage
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

SUPPORTED_TYPES

public static final XSSFRelation[] SUPPORTED_TYPES
Constructor Detail

XSSFExcelExtractor

public XSSFExcelExtractor(java.lang.String path)
                   throws org.apache.xmlbeans.XmlException,
                          OpenXML4JException,
                          java.io.IOException
Deprecated. Use XSSFExcelExtractor(org.apache.poi.openxml4j.opc.OPCPackage) instead.

Throws:
org.apache.xmlbeans.XmlException
OpenXML4JException
java.io.IOException

XSSFExcelExtractor

public XSSFExcelExtractor(OPCPackage container)
                   throws org.apache.xmlbeans.XmlException,
                          OpenXML4JException,
                          java.io.IOException
Throws:
org.apache.xmlbeans.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


setLocale

public void setLocale(java.util.Locale locale)
What Locale should be used for formatting numbers (based on the styles applied to the cells)


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


Copyright 2012 The Apache Software Foundation or its licensors, as applicable.