public class XSSFExcelExtractor extends POIXMLTextExtractor implements ExcelExtractor
Modifier and Type | Field and Description |
---|---|
static XSSFRelation[] |
SUPPORTED_TYPES |
Constructor and Description |
---|
XSSFExcelExtractor(OPCPackage container) |
XSSFExcelExtractor(XSSFWorkbook workbook) |
Modifier and Type | Method and Description |
---|---|
java.lang.String |
getText()
Retrieves 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 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 within textboxes 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)
|
checkMaxTextSize, close, getCoreProperties, getCustomProperties, getDocument, getExtendedProperties, getMetadataTextExtractor, getPackage
setFilesystem
public static final XSSFRelation[] SUPPORTED_TYPES
public XSSFExcelExtractor(OPCPackage container) throws org.apache.xmlbeans.XmlException, OpenXML4JException, java.io.IOException
org.apache.xmlbeans.XmlException
OpenXML4JException
java.io.IOException
public XSSFExcelExtractor(XSSFWorkbook workbook)
public static void main(java.lang.String[] args) throws java.lang.Exception
java.lang.Exception
public void setIncludeSheetNames(boolean includeSheetNames)
setIncludeSheetNames
in interface ExcelExtractor
includeSheetNames
- true
if the sheet names should be includedpublic void setFormulasNotResults(boolean formulasNotResults)
setFormulasNotResults
in interface ExcelExtractor
formulasNotResults
- true
if the formula itself is returnedpublic void setIncludeCellComments(boolean includeCellComments)
setIncludeCellComments
in interface ExcelExtractor
includeCellComments
- true
if cell comments should be includedpublic void setIncludeHeadersFooters(boolean includeHeadersFooters)
setIncludeHeadersFooters
in interface ExcelExtractor
includeHeadersFooters
- true
if headers and footers should be includedpublic void setIncludeTextBoxes(boolean includeTextBoxes)
includeTextBoxes
- public void setLocale(java.util.Locale locale)
public java.lang.String getText()
getText
in interface ExcelExtractor
getText
in class POITextExtractor
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.